copying vlookup

[Guest]

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

 

[T. Valko]

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)

 

[Guest]

you are awesome!
thank you!
jane

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)

 

[T. Valko]

You're welcome. Thanks for the feedback!