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.