Help with Excel Formula VLOOKUP
 

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

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

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

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

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

--
Regards

Roger Govier


"Missy" wrote in message
...
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

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

"Debra Dalgleish" wrote:

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

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

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

"Debra Dalgleish" wrote:


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





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