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

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(A 1,SecondRange,2,false),VLOOKUP(A1,FirstRange,2,fal se))


Vaya con Dios,
Chuck, CABGx3




"RVFmal" wrote:

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.