column letter

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?

Hi, I have message box that I am trying to convert from a column number to column letter to make the code more user friendly as I was performing this on Column AC which is column 29 (much more confusing) How would I go about converting the column number to column letter for this code? c =...

Hi, I have 5 columns, 5 rows like this <tbody> A B C D E 1 a 1 11 a C 2 b 2 12 3 c 3 13 4 d 4 14 5 e 5 15 </tbody> I'd like to use SUM.IF to get the value from the column that is determined by the value in cell E1. The value in E1 is the result of a formula. I'm kind...

Folks: How can I get the column letter corresponding to the column number derived from a match formula? I used the formula: =MATCH(F7,'Headcount'!A1:Z1,0) Note: F7 is the column header name. The cost I'm pulling is under that header in the lookup array. I want to use the column letter to...

Ok, I know there have been like a billion questions about this but there doesn't seem to be a definitive answer and I have come to Mr. Excel to get it. I am using Office 2010 and am responsible for sorting out this huge census files we get from our customers. My issue is I write one Macro and...