This should be simple

[famdamly]

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,

 

[RagDyer]

One way is:

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

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

 

[Biff]

Hi!

Try this:

=INDIRECT("B"&A2)

Biff

 

[pinmaster]

You mean this?

=INDIRECT("B"&Sheet2!A2)

Regards
JG

 

[RagDyer]

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!
==============================================

One way is:

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

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



message news:[email protected]...

 

[famdamly]

Thank you ver much for your help.

 

[Ragdyer]

Appreciate the feed-back.