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
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