+ Reply to Thread
Results 1 to 3 of 3

Vlookup with multiple return

  1. #1
    Registered User
    Join Date
    02-15-2014
    Location
    metro manila, philippines
    MS-Off Ver
    Excel 2007 & 10
    Posts
    43

    Vlookup with multiple return

    Good day Everyone!

    I would like to ask for your help regarding my problem on excel formula. I'm having trouble with creating a list/table in return to searched data. In the attached file, in sheet "SOA", if the user select name of staff (c4), the corresponding value from sheet "Details" should be listed below the table (a8:g43). Unfortunately, when i try the vlookup, it gave me one result in each row. Same also when i used another formula with "Ctrl+Shift+Enter" function (see a8 & a9).

    Thank you in advance...
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,836

    Re: Vlookup with multiple return

    Un merge all the headers in sheet details, Merging cell is not good habit & please ensure that what data headers are in sheet details should be same in sheet SOA.

    Try A18

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


    Check the attached file.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    02-15-2014
    Location
    metro manila, philippines
    MS-Off Ver
    Excel 2007 & 10
    Posts
    43

    Re: Vlookup with multiple return

    Hi Shukla.ankur!

    Thanks for your help. It works...

+ 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. Vlookup to return multiple rows in return
    By Excelhelpss in forum Excel General
    Replies: 1
    Last Post: 06-18-2015, 09:59 AM
  2. Help using vlookup to return multiple results for one vlookup value
    By Akmon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2015, 06:00 AM
  3. [SOLVED] VLOOKUP - return multiple values in same row
    By kahnailee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2015, 11:07 AM
  4. Return multiple columns with vlookup when there are multiple matches
    By elapo21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2013, 07:11 PM
  5. Vlookup function to return multiple values from multiple sheets
    By bsamant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 11:31 AM
  6. VLookup with multiple return cells - Can I sum these up?
    By AnnaG87 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2013, 03:36 PM
  7. VLookup - Return multiple values in multiple cells HELP
    By sreeves1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2012, 12:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1