+ Reply to Thread
Results 1 to 3 of 3

Do I need a V or H lookup or something else?

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    4

    Do I need a V or H lookup or something else?

    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
    Last edited by arif_e; 11-17-2015 at 12:24 PM. Reason: Adjusted title to comply with rules

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Looking for advice on this table, maybe a V or H lookup?

    If you've already got the matrix, can't you just filter the table for TRUE / 1 in the particular column you're interested in? No need to build a second table or anything like that.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Looking for advice on this table, maybe a V or H lookup?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] LOOKUP MIN.VALUE using HLOOKUP or INDEX, MATCH?? - NEED ADVICE
    By meyero90 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-19-2014, 09:40 AM
  2. [SOLVED] Advice, Can I use pivot table or must I use Vba?
    By lucky245 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-31-2014, 06:37 AM
  3. Pivot Table Advice
    By fetster in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-07-2013, 10:31 AM
  4. [SOLVED] Advice on formulas (I think Lookup Function)
    By Karelia Suite in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2013, 07:53 AM
  5. Issue with LOOKUP and Advice on crrect formulae
    By pranabdeb in forum Excel General
    Replies: 8
    Last Post: 04-18-2012, 03:44 AM
  6. Advice on using the LOOKUP function requested
    By ChrisPeter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-20-2010, 08:11 AM
  7. need advice for this skill chart table please
    By graveltrap in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-10-2010, 11:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1