This should be simple
 

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

This should be simple
 

One way is:

=INDEX(B:B,A2)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"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

This should be simple
 

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

This should be simple
 

You mean this?

=INDIRECT("B"&Sheet2!A2)

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=500003

This should be simple
 

Sorry, didn't realize you were talking about different WS's.
The example I posted was where all columns and the formula are on the same
sheet.
=INDEX(B:B,A2)

Actual formula depends on:

where is the formula,
where is the column to lookup,
where is the column to reference.

Could be any of these:
Formula on Sheet1, both columns on Sheet2,
=INDEX(Sheet2!B:B,Sheet2!A2)

Formula on Sheet1, reference column on Sheet1, lookup column on Sheet2,
=INDEX(Sheet2!B:B,A2)

Formula on Sheet1, reference column on Sheet2, lookup column on Sheet1,
=INDEX(B:B,Sheet2!A2)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RagDyer" wrote in message
...
One way is:

=INDEX(B:B,A2)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"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

This should be simple
 

Thank you ver much for your help.


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

This should be simple
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"famdamly" wrote in
message ...

Thank you ver much for your help.


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