I am currently using the following VLOOKUP formula in a spread sheet

=VLOOKUP($A3,Leadtime!$A:$BD,3,0)

What I am wanting to do is copy formula across the row for the next 50
columns. When I do this all column result '3' is copied also. What im
wantin is to coly the fixed parts but what the column number to move to the
next column number ie 3 then 4 then 5.

Can this be done?