Excel Formula - get cell's value which the cell reference is a text

[tombudda]

Hi all,

I'm a newbee on Excel and run into this problem.
Let's say I have a cell A1 = 'Yahoo'
And in cell B1 = 'A'
And if in cell C1, I want to get 'Yahoo' by combining
B1's text with "1". But I don't know how to tell Excel
to refer to the actuall value of the text. I try this but
this will only give me the text of "A1"
=B1 & "1"

Seems like I can't put =&(B1 & "1")..
Any clue.. Thanks!

To

 

[Ragdyer]

With
A
in B1

Try this:

=INDIRECT(B1&1)