+ Reply to Thread
Results 1 to 3 of 3

Mulitple Results from a Vlookup

  1. #1
    Registered User
    Join Date
    02-08-2012
    Location
    Norfolk, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Mulitple Results from a Vlookup

    Hi,

    I hope someone can help me here.

    I am attempting to do a vlookup on the data that is highlighted in yellow and to return matching results on the Employer Number in A3 with L3 pulling through whatever is in Column M i.e. the vlookup for this would be

    = vlookup(A3,L3:N139729,2,False)

    However some of the entries in column A could have multiples in Column M and ideally i need to pull these entries into columns D,E,F etc

    Can someone point me in the right direction please, as i am really struggling now
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,887

    Re: Mulitple Results from a Vlookup

    Like this?
    Attached Files Attached Files
    Last edited by Jacc; 03-08-2013 at 07:18 AM.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Mulitple Results from a Vlookup

    HI Maverick,

    welcome to the forum.

    Try using below formula:-

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


    see attachment:-

    Help Vlookup Multiple.xlsx

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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