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

  • Thread starter Thread starter Guest
  • Start date Start date
An example of what you want?

=VLOOKUP(VLOOKUP(A1,Sheet2!A:B,2),Sheet3!A:D,4,0)

This will lookup the value in Column B of Sheet2 corresponding to A1 and use
this value to retrieve the value from column D of Sheet3.

Is this is what you require?
 
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

vlookup formatting problem 1
vlookup 2
Sum VLOOKUP? 4
how do i use vlookup function in more than one table same time 1
Help With VLOOKUP 2
Vlookup Copy Formula 2
Need to bring back 2 vlookup values 2
Vlookup to reference offset 1

Back
Top