copying vlookup
If you're copying across:
=VLOOKUP($D18,Data!$A$1:$D$500,COLUMNS($A1:B1),0)
If you're copying down:
=VLOOKUP(D$18,Data!$A$1:$D$500,ROWS(A$1:A2),0)
--
Biff
Microsoft Excel MVP
"jane" wrote in message
...
my formula:
=VLOOKUP($D18,'Data$A$1:$D$500'!,2,FALSE)
how can I copy the formula without having to change the hard-coded column
2
to column 3, coulmn 4, etc?
thanks in advance! jane
|