+ Reply to Thread
Results 1 to 3 of 3

Returning multiple values in multiple cells based upon one input

  1. #1
    Registered User
    Join Date
    05-11-2012
    Location
    St. Paul
    MS-Off Ver
    Excel 2010
    Posts
    2

    Returning multiple values in multiple cells based upon one input

    I need to develop a worksheet that automatically populates all invoices for a specific customer based upon the customer number I enter. I want each individual invoice number to populate in a separate cell. I uploaded a file with three tabs. The first tab is the data I am working with (sorted by customer number). The second tab is the statement showing how I want the final result to look (I just copied in the information that I want to see for one particular customer), and the third tab shows the same statement format, but without the end result so that the appropriate formula(s) can be entered to populate the information. I am using Excel 2010.

    I've reviewed other threads, but none seem to get at what I'm trying to do w/o using VB. Any help on this is appreciated.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Returning multiple values in multiple cells based upon one input

    does the attached give you what you want?
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-11-2012
    Location
    St. Paul
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Returning multiple values in multiple cells based upon one input

    This is very helpful to populate columns C D & E (document date, amount and net due date) once the invoice number in column B is populated. Do you have any suggestions for formulas to add to column B to automatically populate all invoice numbers once the customer number in cell C4 is populated? The example file I attached doesn't show multiple customer numbers in the drop down box, but in my actual file, there are multiple customer numbers that I can choose from. When I change the customer number, I want a list of invoice to automatically populate instead of copying and pasting the list of invoice numbers. Any thoughts?

    Thanks again.

+ 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