Help with Excel Formula VLOOKUP

D

Debra Dalgleish

What problem are you having?
If you give an example of your formula, and describe your worksheet
layout, someone may be able to help you.
 
M

Missy

I am trying to compare two spreadsheets that contain the same data but one
spreadsheet contains a row of information that the other does not. I want to
say look at Spreadsheet A Colum F2 and compare to Spreadsheet B Colum E2, if
they match return value from Spreadsheet A I2 into new spreadsheet---Hope I
explained this correctly

I am tried the below formula but I am getting a #N/A
=VLOOKUP('120 Day '!F2,'45 Day '!E2,'45 Day '!I2,FALSE)

Then I tried this formula and I am getting #REF!
=VLOOKUP('120 Day '!E:E,'45 Day '!D:D,I9,FALSE)
 
D

Debra Dalgleish

Maybe an IF formula would work. For example:

=IF('120 Day '!F2='45 Day '!E2,'45 Day '!I2,"No Match")
 
M

Missy

Thanks, this worked partly..It is returning the value in spreadsheet b (45
day) I2 instead of spreadsheet a (120 day)?
 
D

Debra Dalgleish

You're welcome. Change the formula to the following, and it should do
what you want:

=IF('120 Day '!F2='45 Day '!E2,'120 Day '!I2,"No Match")
 
Top