Get column letter from value in cell

[Phil Payne]

This works great for characters A-Z but not for columns after Z. E.g., 'AB' I tried the LEFT ADDRESS MATCH formula which works for Columns >Z but not for those <AA.

Any ideas?

The above refers to solution by VOG "=CHAR(66+MATCH(A1,C1:K1,0))" in 2010.​

I found the above "Return column letter from match or lookup" discussion written a long time ago.

I am struggling to make this work because my range goes beyond column Z to column BW!

Does anyone have a solution please?

 

[RoryA]

Yes, what I just suggested. Can't really comment more specifically without more detail as to your data layout and actual end goal.

 

[Phil Payne]

OK thanks