Multiple results displayed in a vlookup table of data

[davidkruyt]

Good Afternoon
I need to extract multiple date for Mobile numbers that was recharged on different dates.

I have a data table with all the records and a criteria list with the Mobile numbers

I would appreciated support on this.

Thanks

[PaulM100]

Maybe something like this:
Array formula, entered with Ctrl+Shift+Enter instead of regular Enter + an dropdown

=IFERROR(INDEX($B$4:$B$69,SMALL(IF($A$4:$A$69=$H$3,ROW($A$4:$A$69)-ROW($A$4)+1),ROWS($A$4:A4))),"")

[davidkruyt]

Thanks Paul
I was hoping to display results adjacent to each number with having to check each number.

Is this possible?

[PaulM100]

Like this maybe:

=IFERROR(INDEX($B$4:$B$69,SMALL(IF($A$4:$A$69=$F4,ROW($B$4:$B$69)-MIN(ROW($B$4:$B$69))+1),COLUMNS($F$4:F4))),"")

Array as well.

[davidkruyt]

Hi Paul,
Sorry that I did not get back to you with a response but had to travel urgently.

I wondering if you could suggest a similar formula that would provide multiple dates at the
right hand side of the table indicating the dates that the same mobile number was
recharged during other months.

I have the Data table of all transactions dating back to June last year positioned
as the in the first have of the spread sheet which I have checked back to
using a Vlookup that has brought back a positive or negative result in column "AK"

I could email you a dropbox link if you would be willing to help

Many thanks & Kind Regards

[JeteMc]

Your first attachment was only 11.4 Kb so it seems possible that the data table you are speaking of in post #5 may be uploadable to this site.
Let us know if you have any questions.