VLOOKUP to check 2 lists?

[sknight22]

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 1		TRAILER PARK 2
Trailer	Bay			Trailer	Bay
TEST	1	TP1			1	TP2
	2	TP1			2	TP2
	3	TP1			3	TP2
	4	TP1			4	TP2
	5	TP1			5	TP2
	6	TP1			6	TP2
	7	TP1			7	TP2
	8	TP1			8	TP2
	9	TP1			9	TP2
	10	TP1			11	TP2
	11	TP1			12	TP2
	12	TP1			13	TP2
	13	TP1			14	TP2
	14	TP1			15	TP2
	15	TP1			16	TP2
	16	TP1			17	TP2
	17	TP1			18	TP2
	18	TP1			19	TP2
	19	TP1			20	TP2
	20	TP1			21	TP2
	21	TP1			23	TP2
	22	TP1			24	TP2
	23	TP1			25	TP2
	24	TP1			26	TP2
	25	TP1			27	TP2
	26	TP1			28	TP2
	27	TP1			29	TP2
	28	TP1			30	TP2
	29	TP1			31	TP2
	30	TP1			32	TP2
	31	TP1			33	TP2
	32	TP1			34	TP2
	33	TP1			35	TP2
	34	TP1			36	TP2
	35	TP1			37	TP2
					38	TP2
					39	TP2
					40	TP2
					41	TP2
					42	TP2
					43	TP2

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

 

[JazzSP8]

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

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

HTH