Address Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Post the formula

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
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)
 
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
Click to expand...

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





.
Click to expand...
Click to expand...

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
 
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
.
Click to expand...
Click to expand...

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)


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
.
Click to expand...
Click to expand...
 
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?
Click to expand...

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