Maybe an IF formula would work. For example:

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

Missy wrote:
> 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)
>
> "Debra Dalgleish" wrote:
>
>
>>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.
>>
>>Missy wrote:
>>
>>>I am trying to compare two separate spreadsheets and return data onto a new one


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html