View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LostwithoutLost LostwithoutLost is offline
external usenet poster
 
Posts: 14
Default Vlookup and autofill

Can i use autofill to increase the column count it looks in?
On row 1 for example I have =vlookup($b3,sheet1!$a:$cg,5,0) and i then want
to increment it by 3 in the next column
i.e. =vlookup($b3,sheet1!$a:$cg,8,0) and then
=vlookup($b3,sheet1!$a:$cg,11,0) and so on.

Thanks in your advance for your help