A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using a lookup function to output a cell address



 
 
Thread Tools Display Modes
  #1  
Old July 2nd, 2008, 05:32 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 138
Default 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  
Old July 2nd, 2008, 06:32 PM posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
 
Posts: 2,641
Default 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  
Old July 2nd, 2008, 07:30 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 138
Default 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  
Old July 2nd, 2008, 09:13 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 138
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.