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