I use VLOOKUP every day in my job. One thing that has always bugged me about the VLOOKUP function is that I have to manually change the column number that I want to lookup when I'm copying the formula across several columns. I do analysis on data in months, so I never have to change more than 12 columns at a time. Today, I'm having to analyze data in weeks, and will probably be doing this more in the future. I don't want to have to change the column number 52 times to retrieve a year's worth of data from another worksheet. Is it possible to embed another formula in the col_index_num so that the lookup column number will change as I copy it across the columns?
Thanks in advance.
Thanks in advance.