I think you mean

=INDIRECT(A1&7)

where A1 holds the letter in this instance.

--
HTH

Bob Phillips

"Dmitry Kopnichev" wrote in message
...
Hello
How to replace column letter(s) (or column numbers) in refferences with a
result of a function using the old column letter(s) (or column numbers)?