VLOOKUP for 3 Different Worksheets

  • Thread starter Thread starter Toria
  • Start date Start date
T

Toria

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!
 
A general approach to finding a value in three sheets would be as follows:

=IF(ISNA(vlookup_1),IF(ISNA(vlookup_2),IF(ISNA(vlookup_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
 
Back
Top