Draging VLOOKUP to last cell.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mohd21uk - 15 May 2006 13:19 GMT

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.

Reply to this Message

Bob Phillips - 15 May 2006 14:15 GMT

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

Signature

HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

Reply to this Message

mohd21uk - 15 May 2006 14:32 GMT

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 ?

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

Reply to this Message

Bob Phillips - 15 May 2006 15:26 GMT

SorryShould have been

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

Signature

HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

Reply to this Message

mohd21uk - 15 May 2006 16:26 GMT

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

>SorryShould have been
>
[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.

Reply to this Message