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

ITEM	NAME		ITEM	NAME		ITEM	NAME
itemA1	A1		itemB1	B1		itemC1	C1
itemA2	A2		itemB2	B2		itemC2	C2
itemA3	A3		itemB3	B3		itemC3	C3
itemA4	A4		itemB4	B4		itemC4	C4
ITEM	itemB1
NAME

<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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

=IFERROR(VLOOKUP(a7,a2:b5,2,0),IFERROR(VLOOKUP(a7,d2:e5,2,0),IFERROR(VLOOKUP(a7,g2:h5,2,0),"")))

<tbody>
</tbody>

 

[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.