How do I use VLOOKUP to find values across more than 1 sheet or Wo

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

Guest

How do I use the VLOOKUP function to find an exact value across more than one
worksheet and Work Book?

I have a number of workbooks that I need the function to search through to
find the value, but have no idea how to write the formulae to search more
than one worksheet, let alone an entirely different work book.
 
Remember, VLOOKUP wil stop on the first match........

=IF(ISNA(VLOOKUP(A1,FirstRange,2,false)),VLOOKUP(A1,SecondRange,2,false),VLOOKUP(A1,FirstRange,2,false))


Vaya con Dios,
Chuck, CABGx3
 
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 across several sheets 3
vlookup across multiple pages 2
Vlookup across 3 worksheets 2
add multiple returns using vlookup 5
Vlookup and return sheet name also 2
LOOKUP across Multiple Sheets 4
vlookup 2
Vlookup - multiple tabs 5

Back
Top