How to have 2 tables inside Vlookup function?

Hi,

How do I insert another table inside a vlookup function?

this is my current one:

=VLOOKUP(A1,Sheet2!A1:B3,2,FALSE)

But I have another sheet..

How can this current formula be changed to search between two tables (Which are in seperate sheets)

Thanks

Hi

Try in B1 and copy down

Formula:

Please Login or Register  to view this content.