Draging VLOOKUP to last cell.

[mohd21uk via OfficeKB.com]

I have a Sheet1 where Column E has numeriv values. I would like to match
these values with a list in Sheet 2 where Column A contains the numeric list
and Column B contains corresponding values. I want to then return the
corresponding value in Sheet 1 Column G. I would like to then drag this
formula to the last row so that it picks up all the values without returning
an error. I hope that you can help me.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

[Bob Phillips]

=IF(ISNA(VLOOKUP(E2,Sheet1!$A$2:AB$20,2,False)),"",VLOOKUP(E2,Sheet1!$A$2:AB
$20,2,False))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"mohd21uk via OfficeKB.com" <u20517@uwe> wrote in message
news:6049408a7852f@uwe...
> I have a Sheet1 where Column E has numeriv values. I would like to match
> these values with a list in Sheet 2 where Column A contains the numeric
list
> and Column B contains corresponding values. I want to then return the
> corresponding value in Sheet 1 Column G. I would like to then drag this
> formula to the last row so that it picks up all the values without
returning
> an error. I hope that you can help me.
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

[mohd21uk via OfficeKB.com]

The lookup values still change when I drag them to the bottom, providing me
with a N/A error. Is there any way that this can be rectified ?

mohd21uk wrote:
>I have a Sheet1 where Column E has numeriv values. I would like to match
>these values with a list in Sheet 2 where Column A contains the numeric list
>and Column B contains corresponding values. I want to then return the
>corresponding value in Sheet 1 Column G. I would like to then drag this
>formula to the last row so that it picks up all the values without returning
>an error. I hope that you can help me.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

[Bob Phillips]

SorryShould have been

=IF(ISNA(VLOOKUP(E2,Sheet2!$A$2:B$20,2,FALSE)),"",
VLOOKUP(E2,Sheet2!$A$2:B$20,2,FALSE))
--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"mohd21uk via OfficeKB.com" <u20517@uwe> wrote in message
news:6049e345c393a@uwe...
> The lookup values still change when I drag them to the bottom, providing
me
> with a N/A error. Is there any way that this can be rectified ?
>
> mohd21uk wrote:
> >I have a Sheet1 where Column E has numeriv values. I would like to match
> >these values with a list in Sheet 2 where Column A contains the numeric
list
> >and Column B contains corresponding values. I want to then return the
> >corresponding value in Sheet 1 Column G. I would like to then drag this
> >formula to the last row so that it picks up all the values without
returning
> >an error. I hope that you can help me.
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

[mohd21uk via OfficeKB.com]

Sorry but the range still changes when I drag it over the cells. Is there
anything that will avoid this from happening.

Bob Phillips wrote:
>SorryShould have been
>
>=IF(ISNA(VLOOKUP(E2,Sheet2!$A$2:B$20,2,FALSE)),"",
>VLOOKUP(E2,Sheet2!$A$2:B$20,2,FALSE))
>> The lookup values still change when I drag them to the bottom, providing me
>> with a N/A error. Is there any way that this can be rectified ?
>[quoted text clipped - 5 lines]
>> >formula to the last row so that it picks up all the values without returning
>> >an error. I hope that you can help me.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1