Draging VLOOKUP to last cell.

  • Thread starter Thread starter mohd21uk via OfficeKB.com
  • Start date Start date
M

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.
 
=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)
 
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 ?
 
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)
 
Sorry but the range still changes when I drag it over the cells. Is there
anything that will avoid this from happening.

Bob said:
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 ?
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
Back
Top