+ Reply to Thread
Results 1 to 3 of 3

Return Multiple Items with One Lookup Value

  1. #1
    Registered User
    Join Date
    06-17-2015
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    43

    Return Multiple Items with One Lookup Value

    I would like to request all of your help.

    I have tried a few formulas like vlookup, If and others within my little knowledge . But, can't . Tried to google and youtube, not exactly found also.

    Attached is sample file.

    Eg. I key in data in Invoice Details sheet , then want to show automatically in Invoice Format Sheet ..
    If invoice no is 1 , then auto show product name , price, qty in invoice format .

    Usually, one invoice got a few 4-5 products contained. Lookup invoice no, then return multiple results .

    Someone ,can help me please?. Thanks in advance
    Attached Files Attached Files
    Last edited by PMH2384; 09-05-2016 at 01:36 AM.

  2. #2
    Forum Contributor
    Join Date
    05-06-2016
    Location
    Cluj, Romania
    MS-Off Ver
    2007-2010
    Posts
    220

    Re: Return Multiple Items with One Lookup Value

    Hi,
    first unmerge cells C22, C24 in Invoice Format Sheet.
    Then put this array formula (entered with Ctrl+Shift+Enter) in C22
    Formula: copy to clipboard
    Please Login or Register  to view this content.

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

  3. #3
    Registered User
    Join Date
    06-17-2015
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    43

    Re: Return Multiple Items with One Lookup Value

    HI Tudy,

    This great and work perfectly. Thank you with all my heart.

+ 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] Pull data from another sheet based in criteria
    By shreyansgoyal in forum Excel General
    Replies: 2
    Last Post: 03-30-2015, 02:46 AM
  2. Pull data from multiple sheets to one sheet if criteria met
    By Ju1cy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-16-2014, 08:28 AM
  3. Replies: 5
    Last Post: 07-23-2013, 01:17 PM
  4. Pull data from one sheet to another based on criteria
    By lowrymike in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2013, 12:53 PM
  5. Replies: 4
    Last Post: 08-29-2012, 10:32 AM
  6. Pull data from one sheet to another using multiple criteria
    By Farhaad Saleh in forum Excel General
    Replies: 5
    Last Post: 07-22-2011, 10:32 AM
  7. [SOLVED] Pull data from another sheet based on certain criteria
    By steve_sr2 in forum Excel General
    Replies: 1
    Last Post: 02-23-2006, 06:15 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