[mso] Re: Excel.Variable cell reference?
- From: David Good - ANSYS Europe <david.good@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Fri, 2 Aug 2002 14:58:29 -0400
What INDIRECT's not obvious? LOL
Glad I could help,
Dave.
-----Original Message-----
From: Helga Segal
To: Microsoft Office List
Sent: 02/08/02 14:43
Subject: [mso] Re: Excel.Variable cell reference?
Thanks David!!
This is exactly what I was looking for, a way to get a formula to use a
number in a cell as a row number. I was typing words like "Variable,"
and "Reference" into the help search and wasn't coming up with
anything. I never would have thought of the word "Indirect"
On Fri, 2 Aug 2002 14:29:40 -0400 , "David Good - ANSYS Europe"
<david.good@xxxxxxxxx> said:
>
> Hi Helga,
>
> I interpretted your email differently to Linda, so if Linda's
excellent
> explanation is what you're after, please ignore this email :)
>
> The way I saw it was that you want to reference a cell whose location
> is
> indicated in another cell. Confused? It's hard to explain.
>
> Using your example say:
> Sheet1!A1 = 49
> Sheet2!C49 = 20
>
> entering the following formula in Sheet1!A2:
> =INDIRECT("Sheet2!C"&A1)
>
> This will join the text "Sheet2!C" with the contents of A1 (49) giving
> you
> "Sheet2!C49". The INDIRECT function then turns this into a formula
> instead
> of just text (=Sheet2!C49). The result of A2 will be whatever's in
> Sheet2!C49 (20).
>
> Hope this helps.
>
> Dave.
>
> -----Original Message-----
> From: Linda F. Johnson
> To: mso@xxxxxxxxxxxxx
> Sent: 02/08/02 12:54
> Subject: [mso] RE: [mso] Excel.Variable cell reference?
>
>
> Hi Helga....If you want the formula to refer to C49 on Sheet 2, you
> have
> to use Sheet2!C49
>
> So, if you want to be able to add this to A1 in sheet 1, you CAN'T
just
> type 49 in cell A1, you would have to put this is A1:
>
> =Sheet2!C49
>
> Then in your formula in cell A2, just reference A1
>
> The easiest way to reference a cell in another sheet is to do it this
> way...here's an example
>
> Click in cell A1 and type an equal sign ( = )
> Then switch to Sheet 2 and click on cell C49 and hit your Enter key
>
> This will bring you back to Sheet 1 and you will see =Sheet2!C49 has
> been entered into cell A1 for you.
>
> Linda
> Publisher ~ ABC ~ All 'Bout Computers
> Owner ~ Linda's Computer Stop
> http://personal-computer-tutor.com
> FREE MS Office eBook Tutorial
> http://personal-computer-tutor.com/library.htm
>
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of Helga Segal
> Sent: Friday, August 02, 2002 12:41 PM
> To: Microsoft Office List
> Subject: [mso] Excel.Variable cell reference?
>
>
>
> What I'd like to do is have a cell into which I type a number. That
> number will then be used as a row number in a cell reference.
> Apparently, I'm not getting the syntax right.
>
> Say, I type a number 49 into cell A1. Then I'll want the formula in
> A2 to use the number in row 49 in column C on Sheet 2. I've tried
> things like this, which don't work.
>
> +Sheet2!C(A1)
>
> I apparently haven't found the right word to chase down in the help
> files in Excel to solve this riddle.
>
> Helga Segal
>
Helga Segal
helga@xxxxxxxxx
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
