I solved the issue, but I'm wondering if there's a better way to do this. What I have is a column of some named ranges ("NAME"), and I want a formula to the right that looks up the named range and gives me the cell reference ("C352").
I eventually solved it with this:
=CHAR(64+COLUMN(INDIRECT(C2, FALSE)))&ROW(INDIRECT(C2, FALSE))
The CHAR part is to translate the column number (3) to the letter (C), and it doesn't work past column Z.
This shouldn't be the best way to do it. I saw some VBA solutions, is that the only possible way to do this better?