Using a lookup function to output a cell address
 

I want to be able to search for a text string in a column, and have a
function output the cell address. Basically I want to link to a cell that is
offset from a certain text string, however I don't know wheere this cell will
be located. Any ideas?

Thanks

Adam Bush

Using a lookup function to output a cell address
 

Take a look at the match function. It returns the position (not address) of
the matching cell.
--
HTH...

Jim Thomlinson


" wrote:

I want to be able to search for a text string in a column, and have a
function output the cell address. Basically I want to link to a cell that is
offset from a certain text string, however I don't know wheere this cell will
be located. Any ideas?

Thanks

Adam Bush

Using a lookup function to output a cell address
 

Jim,

That just returns the row number of the column I'm looking in. What I need
to be able to do is find the value of the cell offset 1 row 1 column from the
text I'm looking up. Is this possible?

Thanks

Adam Bush

"Jim Thomlinson" wrote:

Take a look at the match function. It returns the position (not address) of
the matching cell.
--
HTH...

Jim Thomlinson


" wrote:

I want to be able to search for a text string in a column, and have a
function output the cell address. Basically I want to link to a cell that is
offset from a certain text string, however I don't know wheere this cell will
be located. Any ideas?

Thanks

Adam Bush

Using a lookup function to output a cell address
 

Jim,

Nevermind, I figured it out. I had to use a complicated combination of
Match, Concatenate, Indirect, and Offset functions but it works.

Thanks

Adam Bush

"Jim Thomlinson" wrote:

Take a look at the match function. It returns the position (not address) of
the matching cell.
--
HTH...

Jim Thomlinson


" wrote:

I want to be able to search for a text string in a column, and have a
function output the cell address. Basically I want to link to a cell that is
offset from a certain text string, however I don't know wheere this cell will
be located. Any ideas?

Thanks

Adam Bush