| From(投稿者): | "ndrewitt" <ndrewitt@tpg.com.au> |
|---|---|
| Newsgroups(投稿グループ): | fj.comp.applications.excel |
| Followup-to(フォローアップ記事の投稿先指定): | fj.comp.applications.excel |
| Subject(見出し): | Need to return the cell reference of a matched search value |
| Date(投稿日時): | 12 Apr 2005 17:58:59 -0700 |
| Organization(所属): | http://groups.google.com |
| Message-ID(記事識別符号): | (G) <1113353939.106563.114000@f14g2000cwb.googlegroups.com> |
I need to find a function or a series of functions, that will allow me to: 1. Search for a cell containing a particular string value (eg Cat) 2. Then have the function return to me the cell reference where the value was found (eg C$2). PLEASE NOTE: It must work across worksheets.