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



"famdamly" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Biff]

Hi!

Try this:

=INDIRECT("B"&A2)

Biff

"famdamly" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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


"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> One way is:
>
> =INDEX(B:B,A2)
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
>
> "famdamly" <[email protected]> wrote
in
> message news:[email protected]...
> >
> > 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
> >
>

[famdamly]

Thank you ver much for your help.

[Ragdyer]

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"famdamly" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>