If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|