Hello everybody, I've been a bit of a lurker and have found loads of help here over the years but finally decided to register as I can't find an answer to this one:
Current state: I'm working in HR recruitment at the moment and we have several interview question documents but each contain multiple competency based questions. For example:
01 contains some questions on Leadership, Time Management, Strategic Thinking and Building Relationships.
02 contains some questions on Building Relationships, Influencing Others and Time management
03 contains some questions on Customer focus, Leadership, Analytical Thinking and Business Awareness
...and so on.
Problem: When a hiring manager asks us for documents containing Leadership questions we don't currently have a system for finding documents containing those questions. In my opinion, questions would be better arranged in documents e.g. Leadership questions document, Time Management questions document etc. But for whatever reason this isn't currently an option.
Aim: Somebody on my team has asked for a spread sheet to index the documents so that if we search for docs containing Leadership, the relevant documents will appear and the hiring manager can then open those documents and extract the questions.
With that out of the way... please see attached and check Sheet 2 for the (unfinished) document list and their contained competencies.
What I'm looking to do is use a validation list to allow the user to select the competencies they require and the lookup shows all documents containing that competency.
What I'd like to ask is - how do I get the validation list to lookup the table and show all the relevant documents based on the query?
Hope I explained that clearly enough, would appreciate any tips or advice!
Note: Had trouble using your file upload system - have hosted it here http://expirebox.com/download/3835af...7625c323d.html
Thanks
Bookmarks