I run into trouble because my variables are numbers not letters and I would prefer not to write a case select statement to convert numbers 1-26 into their letter counterparts.
sorry, I misunderstood what you were asking. There are numerous ways to solve this issue, one of the most straight-forward is to use R1C1 notation in the formula:
Bookmarks