Vlookup

When using vlookup and having the function across more than one column, is there a way of dragging the initial formula across the relevant cells and having the referenced column number increase accordingly?

ie. =VLOOKUP($A$5,$A$9:$F$33,2,0) in cell B5
=VLOOKUP($A$5,$A$9:$F$33,3,0) in cell C5
=VLOOKUP($A$5,$A$9:$F$33,4,0) in cell D5


I dragged the formula over from B5 to C5 and D5 but then had to change the 2 to 3 or 4 etc etc.

Thanks,

Lee