How can I find the right column by its header and use this to other formulas?

[excelos]

Hello!

How can I find the right column by its header and use this to other formulas?

I am thinking to use index match to find the right header by INDEX/MATCH.

But how to I convert the above result into the column code i.e. A:A?

Thanks!

 

[RoryA]

INDEX/MATCH will return a reference to the correct column that you should be able to use directly in other formulas. Depending on your layout it may be more efficient to store the MATCH result in a cell and then refer to it in INDEX formulas wherever you need to refer to that range.

 

[excelos]

INDEX/MATCH will return a reference to the correct column that you should be able to use directly in other formulas. Depending on your layout it may be more efficient to store the MATCH result in a cell and then refer to it in INDEX formulas wherever you need to refer to that range.

Thanks but the return of an INDEX/MATCH is the content of a specific cell. How do I use this as a column reference?

 

[Marcelo Branco]

Thanks but the return of an INDEX/MATCH is the content of a specific cell. How do I use this as a column reference?

Try 0 (zero) as the second argument (row_num) of INDEX

M.