Hi,

I want to ask if there is a way to do a vlookup on a data sheet that I do not know the column index to.

Explanation: the column index is the "Sales" column. However, this column changes with every new data set....and my data set has like 20+ columns.

Question: If the Sales column is in the 20+ columns....is there way to do the look up without manually counting up to the Sales column? How do you do it?

I heard of the indirect formula being useful here, but i don't understand how to use it.

Thanks in advance