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

I need an array formula that will report multiple PO numbers into each cell on the offers sheet. Since PO #2 and #5 have the same offer corresponding to it, I would like for it to report both of the PO numbers on the offer sheet under offer #032515-01.

Yes it would...it wouldn't change anything except mention more than one PO number.The formula is searching for other offer numbers that match the one in the first row, don't see how that'd have any effect on the other data.

Yes and its still returning only one PO number per cell. I believe the last function you mentioned with the small command is the correct one I'm just not sure how to apply that formula to what I'm doing. The "small" formula you wrote out is for the filling out the offer numbers but I need a command that will fill out multiple PO numbers for me. I tried changing it to be for what I'm doing but Im having no luck.

Thanks for your help

Yeah because you really weren't much help, I'm pretty sure you didn't even read what I was asking...What'd you expect?

I'm suppose to be using a small formula correct? I made my initial formula an array formula but it's still returning only one value per cell.