Index and Match Function Help

[Jader04]

Hello Everyone

Can anyone help me with this problem.

I have a customer data sheet that has customer names, dates and amount

then I have another sheet that I want t to find the people have a payment due on the date.

so on top of the sheet, i put the date will find the customer name below

the problem that i have is giving me duplicates or not the person for that date.

see image below

Formula that i used → =(INDEX('Customer Data'!A6:A655,MATCH($F$2,'Customer Data'!$G$4:$G$653,1))&"")

https://snag.gy/rLm5eM.jpg

https://snag.gy/nkBomY.jpg

Thank you for your help

 

[Jader04]

Index and Match Function Help

Hello Everyone

Can anyone help me with this problem?

I have a customer data sheet that has customer names, dates and amount

then I have another sheet that I want t to find the people have a payment due on that date.

So the Result When entering a Date, I want to find all the people are on the list with that date.


See image below

Formula that i used → =(INDEX('Customer Data'!A6:A655,MATCH($F$2,'Customer Data'!$G$4:$G$653,1))&"")
Formula two that i usded → (VLOOKUP(F2,'Customer Data'!A4:I26,MATCH(B20,'Customer Data'!A3:I3,0),0)

https://snag.gy/rLm5eM.jpg

https://snag.gy/nkBomY.jpg

The Worksheet download here → (Password is: Excel ) https://gfile.us/files​

Thank you for your help​

 

[Jader04]

ok I used another Formula =INDEX('Customer Data'!A4:A104,MATCH($F$2,Due_Date'!A4:A104,0),0)

but repeat the same name