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

How do I link a cell in a workbook? 1
Index Match & #values 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Index Match function for lookup HELP 5
Index / Match Formula Problem 4
Word macro that can call cells out of Excel for a find and replace 0
Index and References within a workbook 4
Sumif apllying to all sheets in workbook 2

Top