Index/Match - Return multiple results into one location

[richtks]

I need to return multiple POs to project ID. Is this possible using Index/Match?

Current Formula: =IFERROR(IF(INDEX(Open[PO Number/PO Line '#],MATCH([@[MS1 Key]],Open[MS Key],0))=0,"",INDEX(Open[PO Number/PO Line '#],MATCH([@[MS1 Key]],Open[MS Key],0))),"")

If not, is there another option?

 

[AhoyNC]

If you have Excel 365 or 2021 you could use the FILTER function.
If not then you could probably do it with the INDEX and AGGREGATE function. See link below.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[richtks]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Using 365

 

[Fluff]

Using 365

Please update your profile to show this so that members don't ave to ask every time.

How about

=FILTER(Open[PO Number/PO Line '#],[@[MS1 Key]]=Open[MS Key],"")

But this will not work in a table, so you will need to convert it to a normal range.