Results 1 to 2 of 2

Thread: Vlookup on multiple matches

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-03-2019, 02:15 AM #1
    haiders7
    haiders7 is offline
    Junior Member
    Join Date
    Apr 2019
    Posts
    6
    Rep Power
    0

    Vlookup on multiple matches

    Dear All

    I have a query related to multiple matches through VLookup
    In my attached sheet I have 2 list.

    List1 has Field1 and Time.
    List 2 has Field2

    Field2 matches to Field1 to get the output on column E through Vlookup. But due to mutiple matches I cant have the desired output.

    Desired Output is mentioned on the attached sheet.
    Looking forward to crack this multiple match from my friends.

    Many Thanks
    Haider
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VLookup Across Multiple Tables By Condition
    By mahmoud-lee in forum Excel Help
    Replies: 6
    Last Post: 02-13-2014, 05:50 AM
  2. How do I get Vlookup to return multiple matches?
    By HANOOF in forum Excel Help
    Replies: 1
    Last Post: 06-04-2013, 10:06 PM
  3. Vlookup - Multiple Sheets
    By Suhail in forum Excel Help
    Replies: 3
    Last Post: 01-30-2013, 06:47 PM
  4. Vlookup with multiple criteria
    By patsir in forum Excel Help
    Replies: 7
    Last Post: 08-27-2012, 11:15 AM
  5. VLOOKUP with Multiple Results
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 05-26-2011, 10:29 PM

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
  •  

Forum Rules