Vlookup but don't know the column index number

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

Try something like

=INDEX(A1:Z1000,MATCH(lookupvalue,A1:A1000,0),MATCH("Sales",A1:Z1,0))

Make sure A:Z is sufficient to cover all the possible columns.

Thanks, can this also be done with indirect?

Sure, but it's not necessary.
I tend to avoid Indirect at all costs.

Originally Posted by fayjohn123

Thanks, can this also be done with indirect?