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(A 1,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


On May 18, 2:44 pm, Sanjeev kumar <Sanjeev
wrote:
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?