Address Function

Hello,

I've used the address function to give me data from
several diffrent books, however I would like to use this
data in Chart form, currently im getting '1314.98'!A1,
wat do I need to do to get cell to just read 1314.98?

Thank You,

Ross

Post the formula

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


wrote in message
...
Hello,

I've used the address function to give me data from
several diffrent books, however I would like to use this
data in Chart form, currently im getting '1314.98'!A1,
wat do I need to do to get cell to just read 1314.98?

Thank You,

Ross

The formula reads


=ADDRESS(1,1,4,,'H:\Production\Production Data and
Reports\Daily Production Report\Espoir Daily Production
Report\2004\05-May\[BHP data 03-05-2004.xls]Data-TH'!C7)


-----Original Message-----
Post the formula

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


wrote in message
...
Hello,

I've used the address function to give me data from
several diffrent books, however I would like to use
this
data in Chart form, currently im getting '1314.98'!A1,
wat do I need to do to get cell to just read 1314.98?

Thank You,

Ross


.

On Wed, 28 Jul 2004 05:28:22 -0700,
wrote:

Hello,

I've used the address function to give me data from
several diffrent books, however I would like to use this
data in Chart form, currently im getting '1314.98'!A1,
wat do I need to do to get cell to just read 1314.98?

Thank You,

Ross

Somehow your ADDRESS-function has in the last argument (argument =
"Sheet_text") a formula or cell reference which returns the value 1314.98.
The ADDRESS-function then sees this value as a name for a worksheet.

As Peo also mentions, please show the entire ADDRESS-function, and for
yourself, have a look at the last argument for this function, because this
is probably the culprit.

If you want to have the value of the cell which is returned by the
ADDRESS-function, use the following:

=INDIRECT(ADDRESS(arg1;arg2;arg3;arg4;arg5)

CoRrRan

The formula Reads

=ADDRESS(1,1,4,,'H:\Production\Production Data and
Reports\Daily Production Report\Espoir Daily Production
Report\2004\05-May\[BHP data 01-05-2004.xls]Data-TH'!D7)


Cheers




-----Original Message-----
Post the formula

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


wrote in message
...
Hello,

I've used the address function to give me data from
several diffrent books, however I would like to use
this
data in Chart form, currently im getting '1314.98'!A1,
wat do I need to do to get cell to just read 1314.98?

Thank You,

Ross


.

On Wed, 28 Jul 2004 05:50:56 -0700,
wrote:

The formula reads


=ADDRESS(1,1,4,,'H:\Production\Production Data and
Reports\Daily Production Report\Espoir Daily Production
Report\2004\05-May\[BHP data 03-05-2004.xls]Data-TH'!C7)


-----Original Message-----
Post the formula

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


wrote in message
...
Hello,

I've used the address function to give me data from
several diffrent books, however I would like to use
this
data in Chart form, currently im getting '1314.98'!A1,
wat do I need to do to get cell to just read 1314.98?

Thank You,

Ross


.


I think you are misusing the ADDRESS-function.

Can't you just use the following in your cell (between quotations):
"='H:\Production\Production Data and Reports\Daily Production Report\Espoir
Daily Production Report\2004\05-May\[BHP data 03-05-2004.xls]Data-TH'!C7"

CoRrRan

I dont really understand wat you mena with the arg bit
here (sorry!)
=INDIRECT(ADDRESS(arg1;arg2;arg3;arg4;arg5)

This is the formula im using

=ADDRESS(1,1,4,,'H:\Production\Production Data and
Reports\Daily Production Report\Espoir Daily Production
Report\2004\05-May\[BHP data 01-05-2004.xls]Data-TH'!D8)

Thanks

Ross



Somehow your ADDRESS-function has in the last argument
(argument =
"Sheet_text") a formula or cell reference which returns
the value 1314.98.
The ADDRESS-function then sees this value as a name for
a worksheet.

As Peo also mentions, please show the entire ADDRESS-
function, and for
yourself, have a look at the last argument for this
function, because this
is probably the culprit.

If you want to have the value of the cell which is
returned by the
ADDRESS-function, use the following:

=INDIRECT(ADDRESS(arg1;arg2;arg3;arg4;arg5)

CoRrRan
.

On Wed, 28 Jul 2004 06:24:41 -0700,
wrote:

I dont really understand wat you mena with the arg bit
here (sorry!)
=INDIRECT(ADDRESS(arg1;arg2;arg3;arg4;arg5)

This is the formula im using

=ADDRESS(1,1,4,,'H:\Production\Production Data and
Reports\Daily Production Report\Espoir Daily Production
Report\2004\05-May\[BHP data 01-05-2004.xls]Data-TH'!D8)

Thanks

Ross



Somehow your ADDRESS-function has in the last argument
(argument =
"Sheet_text") a formula or cell reference which returns
the value 1314.98.
The ADDRESS-function then sees this value as a name for
a worksheet.

As Peo also mentions, please show the entire ADDRESS-
function, and for
yourself, have a look at the last argument for this
function, because this
is probably the culprit.

If you want to have the value of the cell which is
returned by the
ADDRESS-function, use the following:

=INDIRECT(ADDRESS(arg1;arg2;arg3;arg4;arg5)

CoRrRan
.


Again: I think you are using the "ADDRESS"-function in an
incorrect-manner... Please explain precisely what you want to happen...

CoRrRan

The question we ask this is why you are using ADDRESS at all when all you
seem to want is to return what's in '[BHP data 01-05-2004.xls]Data-TH'!$D$8
and just linking directly to it will return what you want.

ADDRESS is normally used with variables where you would put in the
row/column variables in cell addresses and wrapped in mostly INDIRECT it
will return the values where the row/column intersect but the way you have
written it will always return what's in '[BHP data
01-05-2004.xls]Data-TH'!$D$8 plus the cell address
as a string depending on the row/column (in your case A1 since you use 1,1
which means row 1 and column 1)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


wrote in message
...
I dont really understand wat you mena with the arg bit
here (sorry!)
=INDIRECT(ADDRESS(arg1;arg2;arg3;arg4;arg5)

This is the formula im using

=ADDRESS(1,1,4,,'H:\Production\Production Data and
Reports\Daily Production Report\Espoir Daily Production
Report\2004\05-May\[BHP data 01-05-2004.xls]Data-TH'!D8)

Thanks

Ross



Somehow your ADDRESS-function has in the last argument
(argument =
"Sheet_text") a formula or cell reference which returns
the value 1314.98.
The ADDRESS-function then sees this value as a name for
a worksheet.

As Peo also mentions, please show the entire ADDRESS-
function, and for
yourself, have a look at the last argument for this
function, because this
is probably the culprit.

If you want to have the value of the cell which is
returned by the
ADDRESS-function, use the following:

=INDIRECT(ADDRESS(arg1;arg2;arg3;arg4;arg5)

CoRrRan
.

Anonymous wrote...
I've used the address function to give me data from several
diffrent books, however I would like to use this data in Chart
form, currently im getting '1314.98'!A1, wat do I need to do to
get cell to just read 1314.98?

What are the *EXACT* formulas you're using that call ADDRESS?


---
Message posted from http://www.ExcelForum.com/