VLOOKUP for 3 Different Worksheets
 

Hello,

Is it possible to compare three columns from three different spreadsheets
using VLOOKUP or another formula? If all three columns are each in column A,
will you please provide the formula(s)?

Thank you!

VLOOKUP for 3 Different Worksheets
 

Need a more detailed explanation.

--
Biff
Microsoft Excel MVP


"Toria" wrote in message
...
Hello,

Is it possible to compare three columns from three different spreadsheets
using VLOOKUP or another formula? If all three columns are each in column
A,
will you please provide the formula(s)?

Thank you!

VLOOKUP for 3 Different Worksheets
 

A general approach to finding a value in three sheets would be as follows:

=IF(ISNA(vlookup_1),IF(ISNA(vlookup_2),IF(ISNA(vlo okup_3),"",
vlookup_3),vlookup_2),vlookup_1)

where vlookup_1 is looking in Sheet1 and will be something like this:

VLOOKUP(A1,Sheet1!A:B,2,0)

if you want to return matching data from column B. vlookup_2 and vlookup_3
will be similar formulae, but looking at Sheet2 and Sheet3 respectively.

Basically the formula will look for a match in Sheet1, returning a value
from there if there is a match, then it will look at Sheet2 and again return
a value if there is a match, and finally it will look in Sheet3. If the
sought item is not in any of the sheets then you will get a blank returned.

Hope this helps.

Pete

"Toria" wrote in message
...
Hello,

Is it possible to compare three columns from three different spreadsheets
using VLOOKUP or another formula? If all three columns are each in column
A,
will you please provide the formula(s)?

Thank you!