Vlookup Formula for two Values

[Nandakumar]

Hi,

I need a formula help on the attache worksheet.

I have two values which needs to be compared if one row contains that value,else it should do normal vlookup.

Hope you understand attached worksheet.

 

[bosco_yip]

In "Formula Required" Sheet D3, formula copy across and down :

=IFERROR(VLOOKUP($B3,Grouping!$B$2:$I$7,COLUMNS($A1:B1),0),VLOOKUP($C3,Grouping!$A$2:$I$7,COLUMNS($A1:C1),0))

Regards

 

[Nandakumar]

Thanks.Perfect.

It works!

In "Formula Required" Sheet D3, formula copy across and down :

=IFERROR(VLOOKUP($B3,Grouping!$B$2:$I$7,COLUMNS($A1:B1),0),VLOOKUP($C3,Grouping!$A$2:$I$7,COLUMNS($A1:C1),0))

Regards