Using the contents of a cell in a formula

C

claytorm

Hi,

Simply:

I have a cell containing another cell address. In another formula
wish to refer to the address in this cell. How do I do this?

In more detail:

I have a formula which searches a long list of data for a particula
value using MATCH, then uses ADDRESS to return a cell reference for th
matched value. I wish to use the cell reference returned in anothe
formula. Is this possible? If not, what is the best way round thi
(apart from typing the reference into the new formula manually).

Many thanks in advance for any help,

Bertie
 
N

Norman Harker

Hi Bertie!

Use INDIRECT.

Description:
Returns a reference indicated by a value provided as text. Volatile.

Syntax:
=INDIRECT(ref_text,a1)

ref_text
is a reference to a cell that contains an A1-style reference, an
R1C1-style reference, a name defined as a reference, or a reference to
a cell as a text string.

a1
A logical value that specifies the A1 (TRUE) or R1C1 (FALSE) reference
style
 
Top