Cell reference with variable column
 

Hi all,

Is there a function or way to say A1 where A is a variable that comes
from another cell to the other cell has just he column letter like B?

Thanks,

Michele

Cell reference with variable column
 

=INDIRECT(C1&"1")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mjones" wrote in message
...
Hi all,

Is there a function or way to say A1 where A is a variable that comes
from another cell to the other cell has just he column letter like B?

Thanks,

Michele

Cell reference with variable column
 

If you put B in A5 then this formula will return what's in B1, if you put C
in A5 it will be C1


=INDIRECT(A5&1)



--


Regards,


Peo Sjoblom


"mjones" wrote in message
...
Hi all,

Is there a function or way to say A1 where A is a variable that comes
from another cell to the other cell has just he column letter like B?

Thanks,

Michele

Cell reference with variable column
 

Hi,

=INDIRECT(F1 & 6)

If F1 contained the letter C then this would return the value of C6

Mike

"mjones" wrote:

Hi all,

Is there a function or way to say A1 where A is a variable that comes
from another cell to the other cell has just he column letter like B?

Thanks,

Michele

Cell reference with variable column
 

On Apr 24, 3:36 pm, Mike H wrote:
Hi,

=INDIRECT(F1 & 6)

If F1 contained the letter C then this would return the value of C6

Mike

"mjones" wrote:
Hi all,

Is there a function or way to say A1 where A is a variable that comes
from another cell to the other cell has just he column letter like B?

Thanks,

Michele

Thanks everyone!