Thread: copying vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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