Adding an Offset to a Column Value

[SidBord]

I often have a formula executing on one sheet referring to
data on another sheet. My problem is that, while I can
determine the column letter of one column, I don't know a
clean way to apecify the column letter that is, say, 2
columns over from the column I start with. In other words,
I want to add a column offset to a known column letter, but
letters don't add well. If I use the Column function, it
returns a number, not a letter. I can add the offset to
that number, but then I can't get the letter equivalent to
the result.
How do you convert a column number into a column letter??

 

[Frank Kabel]

Hi
try something like
=OFFSET($A$1,0,3)
to get the value from D1

 

[Guest]

Thanx, Frank. I knew there had to be something simple.