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

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

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

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

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

--
Regards

Roger Govier


"Missy" <Missy@discussions.microsoft.com> wrote in message
news:4AE8EFF3-3A7E-428B-A257-DEBA4531831E@microsoft.com...
>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" <Missy@discussions.microsoft.com> wrote in message
news:4AE8EFF3-3A7E-428B-A257-DEBA4531831E@microsoft.com...
>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
>>
>>

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

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