Tenspeed39355

06-08-2008, 10:58 AM

Good afternoon guys This one has me stopped.

I am using the VLookup command to retreive data from Sheet2 and put the data in sheet1. I can put a hold on everything in the VLookup command using the $ sign. How do I change the column function so the

VLookup command moves from column to column?

Example. In sheet1 Column B I have =VLookup*$A$,Sheet2!$A$2:$C$50,2,0) When I move across the the row how do I get the column command to go from 2, to 3 and 3 to 4 and 4 to 5?? I have a lot of columns to cover so is there a way to advance the column command

as I move across the ss?? Thanks for any help with this.

Max

I am using the VLookup command to retreive data from Sheet2 and put the data in sheet1. I can put a hold on everything in the VLookup command using the $ sign. How do I change the column function so the

VLookup command moves from column to column?

Example. In sheet1 Column B I have =VLookup*$A$,Sheet2!$A$2:$C$50,2,0) When I move across the the row how do I get the column command to go from 2, to 3 and 3 to 4 and 4 to 5?? I have a lot of columns to cover so is there a way to advance the column command

as I move across the ss?? Thanks for any help with this.

Max