INDEX MATCH MATCH statement to look up the 1st occurrence, 2nd occurrence in a single cell

[Success4me]

As you know, using INDEX MATCH MATCH will only return the first result it finds in my range of data (B10:U29)
I simply want to find a way to adjust my formula so all the occurrence appear in a single cell joined together with a comma

Hoping someone here might be able to assist and offer up a little advice as to what it is I'm missing here. Thanks in advance

[alansidman]

Here is a workaround with a VBA that will give multiple responses. You will need to open the file and look at the VBA

[Success4me]

thanks don't seem to understand would prefer formulas as that is what l understand and that is what l require.
Mine is multiple columns not single columns, can't quite follow

[Success4me]

Here is a workaround with a VBA that will give multiple responses. You will need to open the file and look at the VBA

thanks Alan

it worked with your MLOOKUP

(SOLVED)

[Success4me]

INDEX MATCH MATCH statement to look up the 1st occurrence, 2nd occurrence in multiple columns for the outcome to appear in a single cell separated by a coma

[AliGW]

Does the workbook show what you want?

[Success4me]

I know i have to use INDEX, MATCH and SMALL, ROW functions but how. The workbook by MLOOKUP does not help

[AliGW]

Neither does your sample workbook!

Please post a workbook that shows what you want - mock the results up manually for that data sample. When you have done that and we have a clear picture of what you are after, we can help.

[Success4me]

Thanks AliGW
have included the attachment
would like the outcome to be in column X (29-31,31-33) based on the criteria 2 (in red)

[Success4me]

please see the workbook Attachment 637462

[AliGW]

Where in the attachment have you shown what you want the outcome to look like?

If you want the grid output that is already there, what is wrong with your current formula?

EDIT: Looking at the new attachment that has just appeared, which is identical to the one attached to post #1. This is getting us nowhere.

You need to add a mock-up of how you want the results to look.

[Success4me]

Thanks AliGW,
My current formula only gives me the 1st occurrence (29-31) in column X10 and not the 2nd occurrence of (31-33) but would the outcome to include (29-31,31-33) based on the criteria X9

[Success4me]

l have highlighted it in green if that helps Attachment 637463
thanks in advance

[AliGW]

Sorry, no, it doesn't help at all. I still have no idea what you are trying to do or how you want it to look.

This is your last chance to get help from me before I bow out: WHAT DO YOU WANT THE RESULTS TO LOOK LIKE AND WHERE SHOULD THEY GO?

It's up to you. I'm not going to waste any more of my time on this unless you provide the information I have requested. It's your choice.

[Success4me]

thanks for your patience.
this is my formula =IFERROR(INDEX(C10:U10,MATCH($X$9,D10:V10,0)),"") in X10 based on the criteria X9 (2) The result i get is (29-31) which is right but would to have a multiple result shown in a single cell e.g like (i.e. 29-31,31-33 shown in Z10 but can't seem to figure a way out.

Attachment 637467)

Most formula l know is based on two columns but l have multiple columns

[AliGW]

No, I'm still not 100% clear on what we are aiming for here.

I'll step aside and hope that someone else can see through the mist. Good luck!

[Success4me]

Thanks I am truly grateful for taking the time to help i really appreciate it