Vlookup on 3 or more table arrays

[gaurav4698]

How can apply vlookup formula to get value from 3 or more arrays ?
Please help

 

[gaurav4698]

EG how can i use Vlookup to find NAME from following 3 tables

[TABLE="width: 512"]
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ITEM[/TD]
[TD="width: 64"]NAME[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]ITEM[/TD]
[TD="width: 64"]NAME[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]ITEM[/TD]
[TD="width: 64"]NAME[/TD]
[/TR]
[TR]
[TD]itemA1[/TD]
[TD]A1[/TD]
[TD][/TD]
[TD]itemB1[/TD]
[TD]B1[/TD]
[TD][/TD]
[TD]itemC1[/TD]
[TD]C1[/TD]
[/TR]
[TR]
[TD]itemA2[/TD]
[TD]A2[/TD]
[TD][/TD]
[TD]itemB2[/TD]
[TD]B2[/TD]
[TD][/TD]
[TD]itemC2[/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD]itemA3[/TD]
[TD]A3[/TD]
[TD][/TD]
[TD]itemB3[/TD]
[TD]B3[/TD]
[TD][/TD]
[TD]itemC3[/TD]
[TD]C3[/TD]
[/TR]
[TR]
[TD]itemA4[/TD]
[TD]A4[/TD]
[TD][/TD]
[TD]itemB4[/TD]
[TD]B4[/TD]
[TD][/TD]
[TD]itemC4[/TD]
[TD]C4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ITEM[/TD]
[TD]itemB1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Mike Szczesny]

Assume are your data tables are A1:B5, d1:e5, and g1:h5. Assume headers are in row 1. Therefore your actual data ranges are A2:B5, d2:e5, and g2:h5 item is in columns A, D, and G. Name is in columns B,E, and H.

A7: item
A8: Formula[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"] =IFERROR(VLOOKUP(a7,a2:b5,2,0),IFERROR(VLOOKUP(a7,d2:e5,2,0),IFERROR(VLOOKUP(a7,g2:h5,2,0),"")))[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

If the return is supposed to be a text value, try:

=LOOKUP(REPT("z".255),CHOOSE({1,2,3,4},"",VLOOKUP("ItemB1",A:B,2,0),
  VLOOKUP("ItemB1",C:D,2,0),VLOOKUP("ItemB1",E:F,2,0)))

 

[gaurav4698]

Thanks for the help Aladin your solution worked fine.

 

[Aladin Akyurek]

Thanks for the help Aladin your solution worked fine.

You are welcome.