Posts by Faysalalam2008

[TABLE="width: 732"]

[tr]

[td]

code1

[/td]

[td]

code2

[/td]

[td][/td]

[td]

lookup Range1

[/td]

[td]

lookup Range2

[/td]

[td]

Return Value

[/td]

[td][/td]

[td]

Lookup

[/td]

[td]

Multiple Return

[/td]

[/tr]

[tr]

[td]

1001-01

[/td]

[td]

PET

[/td]

[td]

[/td]

[td]

1001-01

[/td]

[td]

PET

[/td]

[TD="align: right"]Red
[/TD]

[td][/td]

[td]

1001-01 & PET

[/td]

[TD="align: right"]Red,Green
[/TD]

[/tr]

[tr]

[td]

1001-01

[/td]

[td]

PET

[/td]

[td]

[/td]

[td]

1001-01

[/td]

[td]

PET

[/td]

[TD="align: right"]Green
[/TD]

[td][/td]

[td]

1001-01 & MPET

[/td]

[td]

Blue

[/td]

[/tr]

[tr]

[td]

1001-02

[/td]

[td]

PET

[/td]

[td][/td]

[td]

1001-02

[/td]

[td]

PET

[/td]

[td]

Blue

[/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[td]

1002-03

[/td]

[td]

MPET

[/td]

[td][/td]

[td]

1002-03

[/td]

[td]

MPET

[/td]

[TD="align: right"]Green
[/TD]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[td]

1001-01

[/td]

[td]

MPET

[/td]

[td]

[/td]

[td]

1001-01

[/td]

[td]

MPET

[/td]

[TD="align: right"]Blue
[/TD]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[/TABLE]

I am trying to vlookup multiple value and return multiple values in one cell