VLOOKUP to check 2 lists?

sknight22

Board Regular
Joined
Feb 16, 2016
Messages
67
Hi,

I would like to search the 2 lists below for a specific trailer number and return the bay number. Is it possible to search both lists?


TRAILER PARK 1TRAILER PARK 2
TrailerBay TrailerBay
TEST1TP1 1TP2
2TP1 2TP2
3TP1 3TP2
4TP1 4TP2
5TP1 5TP2
6TP1 6TP2
7TP1 7TP2
8TP1 8TP2
9TP1 9TP2
10TP1 11TP2
11TP1 12TP2
12TP1 13TP2
13TP1 14TP2
14TP1 15TP2
15TP1 16TP2
16TP1 17TP2
17TP1 18TP2
18TP1 19TP2
19TP1 20TP2
20TP1 21TP2
21TP1 23TP2
22TP1 24TP2
23TP1 25TP2
24TP1 26TP2
25TP1 27TP2
26TP1 28TP2
27TP1 29TP2
28TP1 30TP2
29TP1 31TP2
30TP1 32TP2
31TP1 33TP2
32TP1 34TP2
33TP1 35TP2
34TP1 36TP2
35TP1 37TP2
38TP2
39TP2
40TP2
41TP2
42TP2
43TP2

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

JazzSP8

Well-known Member
Joined
Sep 30, 2005
Messages
1,223
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
Hi

If you know you're going to return an error if it's not found in the first table then you can check for that error and use it to check the second.

Something along the lines of...

Code:
=IFERROR(VLOOKUP(VAL,TAB,IND,FALSE),VLOOKUP(VAL,TAB2,IND,FALSE))

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,650
Members
414,399
Latest member
Ninjee

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top