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