How do I search a whole workbook using the =INDEX function?

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 129

How do I search a whole workbook using the =INDEX function?

I am trying to search an entire workbook for a text string e.g. "Fred". This
could be on one of many worksheets but will be in column A. When this has
been found, I want the value in column Q to be returned. I am trying to do
this using the =INDEX(#####,MATCH(A3, ######,0),17) command where I want
##### to be the entire workbook.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using INDEX & MATCH to search different columns	Scott A[_2_]	Excel Discussion (Misc queries)	3	January 26th 09 07:32 AM
How can I use a VLOOKUP function to search a multi-page workbook?	Chrisl147	Excel Worksheet Functions	4	August 17th 07 05:16 PM
How can I use a VLOOKUP function to search a multi-page workbook?	Toppers	Excel Worksheet Functions	0	August 17th 07 01:46 AM
How to use an index number in a search range	Nick Krill	Excel Worksheet Functions	2	January 12th 06 06:16 PM
VLookup function to search an entire workbook	liseladele	Excel Worksheet Functions	0	November 10th 05 12:35 AM

All times are GMT +1. The time now is 07:32 AM.

Menu

About Us