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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i use vlookup function in more than one table same time 1
vlookup formatting problem 1
vlookup 2
Sum VLOOKUP? 4
Vlookup to reference offset 1
VLOOKUP 2
Vlookup Function 3
Alternative of Vlookup function which improves speed 4

Back
Top