INDIRECT function

A

Arypzokop

Hi group.

Where could I find some good, detailed explanation of the
uses of the Indirect function? I find the online help
absolutely useless on this particular topic.

I don't even understand why and when this function could
be useful.
 
F

Frank Kabel

Hi
one usage:
- say you have some sheets which are name like a month name (e.g.
January, February, etc.)
- on a different sheet you want to show the value of cell X1 from one
of these month sheets. But you don't want to use a formula like
='January'!X1
and change the formula manually if you want a different month. Instead
you want to insert the month name in a cell (e.g. depending on the
current month).

So try the following on a summary sheet:
in cell A1 enter the formula
=TEXT(TODAY(),"MMMM")
this will show the current month name

now enter the following formula in B1 to show the cell X1 from the
respective month sheet defined in cell A1:
=INDIRECT("'" & A1 & "'X1")

now if cell A1 changes the other formula result changes without any
manual action.

For further usage examples just search Google for INDIRECT
 
A

Arypzokop

thank you Frank

-----Original Message-----
Hi
one usage:
- say you have some sheets which are name like a month name (e.g.
January, February, etc.)
- on a different sheet you want to show the value of cell X1 from one
of these month sheets. But you don't want to use a formula like
='January'!X1
and change the formula manually if you want a different month. Instead
you want to insert the month name in a cell (e.g. depending on the
current month).

So try the following on a summary sheet:
in cell A1 enter the formula
=TEXT(TODAY(),"MMMM")
this will show the current month name

now enter the following formula in B1 to show the cell X1 from the
respective month sheet defined in cell A1:
=INDIRECT("'" & A1 & "'X1")

now if cell A1 changes the other formula result changes without any
manual action.

For further usage examples just search Google for INDIRECT


--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Top