PDA

View Full Version : VLookup and column indicator



Tenspeed39355
05-05-2008, 06:13 AM
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
05-05-2008, 07:05 AM
Check out the file attached and the formula in it...

Tenspeed39355
05-05-2008, 10:27 AM
I guess I need to reply to read the attachment

Bob Phillips
05-05-2008, 10:51 AM
=Vlookup($A$2,Sheet2!A1:Z1,COLUMN(B1),0)

Aussiebear
05-06-2008, 01:14 AM
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
05-07-2008, 06:32 AM
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
05-07-2008, 08:20 AM
I showed you how.

Tenspeed39355
05-07-2008, 09:10 AM
Ok thanks for your help
Max