Address Function

[Guest]

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

 

[Peo Sjoblom]

Post the formula

--

Regards,

Peo Sjoblom

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

 

[Guest]

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)

 

[CoRrRan]

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

 

[Guest]

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

 

[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 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)





.

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

 

[Guest]

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

 

[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
.

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

CoRrRan

 

[Peo Sjoblom]

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)

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
.

 

[hgrove]

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