View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gswegan
 
Posts: n/a
Default How can I change a # in an array formula for a whole column?

I need to change a VLOOKUP formula =VLOOKUP(D566,'Master
Data'!$A$3:$Y$438,25,FALSE)
The 438 should be 1000. Can I change for the whole column or one cell at a
time?