+ Reply to Thread
Results 1 to 4 of 4

Formula for returning multiple returns

  1. #1
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    117

    Formula for returning multiple returns

    Dear Forum.

    Hoping someone can help me out with this.

    Iím looking for a formula that will produce values associated with another cellís value.

    In the sample workbook on sheet 1 there is entry in G17:R25. On sheet 2 I want to have formulas in G10:P10 and/or in G15:G31 that will report the correct information from sheet 1 (Iím hoping this will make sense when you see it as itís a little difficult to describe). I have manually put in the returns that Iíd be expecting. I have highlighted G10:P10 & G15:31 as ideally I could have a formula for each way as I am not sure of the final layout in the actual real world workbook yet.
    If this needs an Array formula that is fine but if it can be done otherwise, that would be preferable.
    Assistance is very much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2007, 2010
    Posts
    4,979

    Re: Formula for returning multiple returns

    hi there. try these array formulas below. for G10:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


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


    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Formula for returning multiple returns

    You are a star benishiryo!! Thank you very much. This will make a sweet addition to the actual workbook .

  4. #4
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Formula for returning multiple returns

    To Admin/Moderator - When I try to go back into my original post to mark as solved for some reason my original text is gone. If I just try to mark as solved I get an error message saying that there needs to be at least 10 characters. I don't want to overwrite the existing by putting text in. Please advise if you require anything from me in this regards. Thank you!

+ 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