View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MP MP is offline
external usenet poster
 
Posts: 39
Default Vlookup, Column Index Num and Autofill

If I have a vlookup in one cell and I try to autofill across multiple
columns, how do get the column index num reference to increase by one as I
autofill across. It appears as though the column index number is always an
absolute value.

Example
Column A Column B
Vlookup($A3,$C$1:$F$12,1,false) Vlookup(($A3,$C$1:$F$12,2,false)