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

W

Will

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index and References within a workbook 4
Index & multiple sheets in one workbook 6
Hyperlink worksheet data to a index in a workbook? 1
Building closed workbook file path within an Index Function 6
Set non-continuous PrintArea via Function / Name 0
Adding OR to an index match formula 2
Index match combination 4
Search Entire Sheet instead of 1? 4

Top