Search for matching workbook and return value from cell

Apologies if this has been asked before but I’m not sure how to word a search for this problem!

I’m trying to create a summary document for a directory of files. The idea is that you can type in the unique id for a file you’re looking for, and it will automatically return the information inside.

I can achieve this by linking to the cell in the relevant file, but this will be too complicated for my team so I want it to link just by matching the unique id in the filename. 

I’ve tried various soltuions with VBA, MS Query, and hyperlinks and vlookups, but I’m a novice with excel and it’s not working. Any ideas? 



By: Emily

Leave a Reply

Your email address will not be published. Required fields are marked *