# Vlookup on 3 or more table arrays

#### gaurav4698

##### New Member
How can apply vlookup formula to get value from 3 or more arrays ?

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### gaurav4698

##### New Member
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

##### Active Member
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>

##### MrExcel MVP
If the return is supposed to be a text value, try:
Rich (BB code):
``````=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)))
``````

You are welcome.

Replies
6
Views
93
Replies
6
Views
108
Replies
4
Views
93
Replies
3
Views
132
Replies
1
Views
104

1,191,536
Messages
5,987,162
Members
440,082
Latest member
belodelokelo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back