+ Reply to Thread
Results 1 to 7 of 7

VLookup - Single value lookup returning multiple records into multiple columns

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    VLookup - Single value lookup returning multiple records into multiple columns

    Certification and Training tracking.xlsx

    I'm sure this is very simple. I've seen it done, but for the life of me, I cannot make it happen.

    I want to create a certification only list on a separate tab of training that has been completed where a certification has been issued (as indicated by a "Y" in the "Certification?" column on the training tracking tab) and then populate from some of the fields vs. all of the fields.

    What I have now, only pulls the first occurence, not all occurences. I saw that I could have identified the multiple columns that needed to be populated, but it didn't work either, so I'm fine putting a separate vlookup in each column.

    I have attached the file just in case I didn't explain my problem well.

    Thank you in advance for your assistance. I appreciate it.

    kllovin

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: VLookup - Single value lookup returning multiple records into multiple columns

    Hi

    In A4 and copy down use this ARRAY formula. Change the red part of the formula for the other columns.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    -- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
    Not just Enter.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: VLookup - Single value lookup returning multiple records into multiple columns

    Well, a few examples of what you expect, from what is given would help, for instance, this looks like you want to see an employees record of training, but which employee? (where do we make the decision of what's needed to be displayed?)
    OR
    are you looking for all employees that meet certain criteria? If so, where do we get the criteria from?
    OR
    Do you want to see employees that meet all but 1 criteria? or 2?...etc....
    While I appreciate the file to work with, without explanation of what should appear, I truly have no idea what you actually want
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  4. #4
    Registered User
    Join Date
    02-07-2014
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: VLookup - Single value lookup returning multiple records into multiple columns

    Certification and Training tracking.xlsx

    Hi dredwolf...

    Thanks for the response.

    What I want is a listing of everything where Certification = "Y"

    Then displayed would be Certification?, Employee Name, Course Name, End Date, Referral Date

    Fotis' formula worked except lines 10 - 13.

    I've reattached the file with the formula that worked in it.

    Thank you. I appreciate your feedback.

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: VLookup - Single value lookup returning multiple records into multiple columns

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    It's because you didn't locked the reference in the red part of the formula.

  6. #6
    Registered User
    Join Date
    02-07-2014
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: VLookup - Single value lookup returning multiple records into multiple columns

    Got it!! Told you it was a user error.

    THANK YOU!! I really appreciate your help!!

  7. #7
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: VLookup - Single value lookup returning multiple records into multiple columns

    You are welcome and thanks for the feed back.

+ 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. Lookup single value across multiple columns
    By ExcelFiend in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2013, 08:25 PM
  2. Replies: 5
    Last Post: 05-04-2011, 06:51 PM
  3. Returning a multiple-result lookup to a single cell
    By shockeroo in forum Excel General
    Replies: 2
    Last Post: 04-17-2009, 03:54 PM
  4. Replies: 2
    Last Post: 08-31-2006, 03:06 PM
  5. *Urgent* vlookup returning multiple columns
    By benj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2005, 02:28 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