Hey guys,

I'm working to build an index/query function to return data based off text.

Starting in B1, I have specific text that I need to lookup in another workbook on a shared drive. The path is as follows: 'B:\Testing\Test2\Test3\[Test This.xlsx]'

I need to return all rows from Test This.xlsx that match B1 text. The B1 text is located located in Column C of Test This.xlsx. There will be multiple matches. I just need all the matches and subsequent rows to be returned.

This is what I have so far, and it doesn't work. I'm sure it needs to be more elaborate. 

Please Login or Register  to view this content.