+ Reply to Thread
Results 1 to 8 of 8

Formula to display associated matched results

  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    earth
    MS-Off Ver
    Excel 2010
    Posts
    23

    Formula to display associated matched results

    trying to display results that match search criteria and display associated data

    note there may be multiple orders for the same item but on a different order which can mean different quantity for that order.

    so i wolud need to display duplicates and their actual # ordered quantity

    I have Column M working but i cant figure how to display associated data in Column J, K and L
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Formula to display associated matched results

    Hi,

    In cell J2 (Purchase_Orders), use this array formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Note: and array formula needs to be entered using Ctrl + Shift + Enter, instead of just Enter. This formula can then be copied down and across as far as is necessary.

    I hope this helps
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-07-2011
    Location
    earth
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Formula to display associated matched results

    i tried using yoru forumla in Column J, it doesnt work with my actual spreadsheet
    Attached Files Attached Files
    Last edited by hotwax; 07-02-2014 at 09:09 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Formula to display associated matched results

    Because you hadn't told me that your search wasn't in fact an entire match, and had to potentially cater for partial matches.

    Try this instead...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-07-2011
    Location
    earth
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Formula to display associated matched results

    When I drag down the formulas in J2-M2 to J1000-M1000, the results stop at the first row. Am I dragging it down incorrectly?

    also i am curious when i highlight one of the formulas, they are in curly brackets instead of beginning with an equal sign.

    can you explain that to me?
    Last edited by hotwax; 07-02-2014 at 10:02 PM.

  6. #6
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Formula to display associated matched results

    Are you re-entering the formulas or using the ones in the spreadsheet that I just uploaded before?

    If you are re-entering, make sure you are using Ctrl + Shift + Enter, as opposed to just Enter, as these are array formulas.

    If you are using my spreadsheet version, then the dragging should already work, as I already dragged the formulas down to row 41 for you.

    Let me know

  7. #7
    Registered User
    Join Date
    09-07-2011
    Location
    earth
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Formula to display associated matched results

    i am re-entering formulas just so i can reproduce it from scratch.

    i understand setting up the array now

    thank you so much for your help. i have so much to learn

  8. #8
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Formula to display associated matched results

    No problems

    Please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks

+ 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] Create Data validation list from matched criteria value results
    By lukeeb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-10-2014, 10:39 PM
  2. Search results of a column display a set value in another column if matched
    By rkrause54 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-12-2013, 01:59 PM
  3. Replies: 3
    Last Post: 06-19-2013, 03:40 AM
  4. [SOLVED] How to write matched results to a specific cell.
    By shart2k12 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2013, 10:17 AM
  5. [SOLVED] Display the results not the formula in the task bar
    By Paul K. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2005, 07:05 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