copying vlookup
 

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

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

copying vlookup
 

you are awesome!
thank you!
jane

"T. Valko" wrote:

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

copying vlookup
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"jane" wrote in message
...
you are awesome!
thank you!
jane

"T. Valko" wrote:

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