how do i use vlookup function in more than one table same time

S

Sanjeev kumar

i want to use vlookup function in a table but my main data is in two
different tables. Is it possible what I use a macro for it?
 
P

Pete_UK

Assuming you have named your tables table_1 and table_2, then you can
use this formula:

=IF(ISNA(VLOOKUP(A1,table_1,2,0)),IF(ISNA(VLOOKUP(A1,table_2,
2,0)),"absent",VLOOKUP(A1,table_2,2,0)­),VLOOKUP(A1,table_1,
2,0))

Where A1 contains the value you are trying to match. I've assumed you
want to bring data back from the second column of the tables if you
find a match, and if there is no match in either table you will get
the word "absent".

Hope this helps.

Pete
 
Top