Results 1 to 11 of 11

Index/Match Formula to return multiple results

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Boulder, Colorado
    MS-Off Ver
    2016
    Posts
    45

    Index/Match Formula to return multiple results

    Hi, So I've created a formula that automatically returns the PO number to the corresponding offer it is referencing...and vice versa. The issue I am having is that occasionally there are several PO's which are for a single offer, though the formula I've created only returns the first PO number that it finds when I'd prefer it to report every PO number that is connected to the single offer. I understand there is something to do with an array formula and using Control-shift-enter when entering the formula but I can't figure out what to do to report multiple PO numbers.

    I'll attach a sample file, The formula I am currently using is:

    =IFERROR(INDEX(Pos!$A$2:$A$22,INDEX(MATCH(A2,Pos!$H$2:$H$22,0),0)),"")

    Thanks for all your help
    Mike Stafford
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 10-16-2016, 02:33 AM
  2. [SOLVED] SUM(IF(INDEX(MATCH()))) Confusion to return multiple results and count how many
    By athickett in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-06-2014, 02:46 PM
  3. Using Index And Match To Return Potential Multiple Results To One Cell
    By jcaynes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2013, 10:41 AM
  4. Using Index Match to return multiple results with very messy data.
    By falkon007 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-30-2013, 12:28 PM
  5. Can Index or Match return multiple results?
    By waverider in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-30-2007, 10:06 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