VLookup and column indicator

[Tenspeed39355]

Good morning. I am using the VLoookup command to look to another sheet
for data. I need to bring over all the data that is is row one. This might be
50 cells. I can get the Vlookup command to work just fine what I need to know is how do I get the column indecator to change for each cell when
entering the vlookupcommand?
Example =Vlookup(A2,Sheet2!A1:Z1,2,0) How do I get the 2 to change to
3 and then 4,5,6. I can set up the Vlookup command and manual change
the column indecator but that is a job. Thanks for your help
Max

[rangudu_2008]

Check out the file attached and the formula in it...

[Tenspeed39355]

I guess I need to reply to read the attachment

[Bob Phillips]

=Vlookup($A$2,Sheet2!A1:Z1,COLUMN(B1),0)

[Aussiebear]

I guess I need to reply to read the attachment

Why???

Simply click on the attached file and it will open for you. Replying is a matter of courtesy to the other person trying to assist you.

[Tenspeed39355]

I still have not been able to get the right formula for moving JUST the
column indicator. This is what I need to do. Example:
=VLookup($A$1,Sheet2!$A$1:$Z$1,2,0). I need the formula to stay the same with the exception of the column indecator. When I move across from A to Z I need the comumn indecator to change from 2 to 3 and from 3 to 4 until I get to Z. Can this be done?? Thanks for your time with this.
Max

[Bob Phillips]

I showed you how.

[Tenspeed39355]

Ok thanks for your help
Max