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.

 

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

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 ?

 

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

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

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