match more then one solution

[Evolta]

Hello,

I have this formula:
=IFERROR(INDEX(Data!$A$3:$AX$500;MATCH(Agenda!$B4;Data!$AX$3:$AX$500;0);4);"")

It matches the date in Agenda!$B4 with the one in Data!$AX$3:$AX$500.
But it's possible that the value in Agenda!$B4 can be found more then once in Data!$AX$3:$AX$500

I can insert extra helper columns if needed.
Help me please

[:) Sixthsense :)]

What needs to happen if there is multiple matches/results?

Better please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[Evolta]

Hopefully this sample sheet will help.
The real one is of course bigger, but I have the assumption that there will never be more than 10 "klanten" (customers)

Evolta.xlsx

[:) Sixthsense :)]

In D3 Cell of Agenda Sheet - Array Formula - Requires CTRL+SHIFT+ENTER

=IFERROR(INDEX(Data!$C$2:$C$16,SMALL(IF((Data!$B$2:$B$16=$B3),ROW(Data!$B$2:$B$16)-MIN(ROW(Data!$B$2:$B$16))+1),COLUMN(A1))),"")

Drag it down and right...

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

[azumi]

See the file attach

Azumi

[azumi]

Non Array Formula

just hit enter button

Azumi

[Evolta]

Thanks both,
I'll examine both the solutions and try to understand them. Yet again it's proven that more then one road leads to Rome :D