Using a lookup function to output a cell address

[adambush4242]

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

 

[Jim Thomlinson]

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

 

[adambush4242]

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

 

[adambush4242]

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