Index and Match OR Vlookup Formula 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 (Daily Promise) that I want t to find the people have a payment due on that date.


So the Result When entering a Date (on Daily Promise page), I want to find all the people are on the list (Data page) 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))&"")


https://snag.gy/rLm5eM.jpg


https://snag.gy/nkBomY.jpg


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


Thank you for your help

 

[Special-K99]

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

It wants to charge me a dollar to download the file!!!!
For crying out load don't use that website anymore!!!

 

[Jader04]

ok try this one
https://www.4shared.com/file/IfbEIl-Qei/Customer_Data.html

 

[Special-K99]

I'm having trouble with that site.
I'm either having to login to an account or download via Facebook - cant do that am at work.

Some free file hosting sites here

https://www.google.co.uk/?gws_rd=ssl#q=free+file+hosting+sites

 

[Jader04]

Hello Special K99 Thank you for your help

ok I add to one of your recommendation→ [FONT=&quot]https://sabercathost.com/9azY/Customer_Data.xlsm[/FONT]

 

[Jader04]

Hello I been trying to figure the formula but keep getting an error

the last formula that test was → INDEX(Customer_data,SMALL(IF(customer_data$G$1:$G$8=$E$1,ROW(customer_data$G$1:$g$8)),ROW(1:1)),2))

I think the error in the last Row(1:1)),2 because is another sheet not in the same.

something similar to this link How To Return Multiple Match Values in Excel Using INDEX-MATCH or VLOOKUP

Anyways any help is appreciated THANK YOU ALL

 

[Aladin Akyurek]

What do you have in E1?

 

[Jader04]

E1 in which page?
if is the customer data page on E1 is simply the header and if the Daily promise page has only the header too

You can DOWNLOAD the workbook here → https://sabercathost.com/9azY/Customer_Data.xlsm