Hi!

Try this:

=INDIRECT("B"&A2)

Biff

"famdamly" wrote in
message ...

I just need to reference a cell in another worksheet with a variable.

Like let's say
A1=1
A2=2
A3=3

B1=red
B2=white
B3=blue

Here's where I'm having trouble.

I want C1 to equal B(a2)

or in effect white

But I can't figure out the formula.

From what I learned
I think it should be C1="b"& Other Sheet.indirect(a2)
but it's not working for me.


Please help, this is frustrating as all get out,


--
famdamly
------------------------------------------------------------------------
famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=500003