Help with Excel Formula VLOOKUP

[Guest]

I am trying to compare two separate spreadsheets and return data onto a new one

 

[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.

 

[Guest]

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,I9,FALSE)

 

[Debra Dalgleish]

Maybe an IF formula would work. For example:

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

 

[Roger Govier]

Hi Missy
One way
=IF('120 Day'!F2='45 Day'!E2,'45 Day'!I2,"")

 

[Guest]

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

 

[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")