Help with Excel Formula VLOOKUP

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

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

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

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