FUNCTION to convert numbers to letters

[Karen]

I want to use the INDIRECT function to capture a reference
that is 2 columns to the left of the one in which I'm
writing the equation. Unfortunately, if I use COLUMN()-2,
that generates the number associated with the column, but
the INDIRECT function only reads letters. Is there a
function that will convert that number into the
corresponding column letter? (other than doing some hand-
created list with the MATCH function).

Thanks,
Karen

 

[Peo Sjoblom]

One way

=INDIRECT(ADDRESS(ROW(),COLUMN()-2))

 

[Harlan Grove]

One way

=INDIRECT(ADDRESS(ROW(),COLUMN()-2))

And another: =INDIRECT("RC[-2]",0)