| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Lookup, and Return Cell Address | Excel Worksheet Functions | |||
| Use Cell Address Lookup in formula | Excel Worksheet Functions | |||
| Use function output as a cell reference | Excel Worksheet Functions | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
Linear Mode
