Hi Forum members,
I am partly retired and putting together a spreadsheet for a friend's business with retail and trade sales.
I am using an array formula containing index match to match today's date with the date, and hence the customer, for orders that have to be delivered - so there can be 20+ orders that will be be found with this method if I drag the formula down the page. I would like to display all the matches in the data validation drop down menu and allow the user to make a choice. From the choice this will populate the invoice and allow it to be printed.
{=INDEX('Sales & Orders'!$A:$A,MATCH(TODAY(),'Sales & Orders'!$B:$B,0))}
I have been looking in many different forums for an example that does similar to what I am asking but to no avail.
The data I am referencing is found on a another tab with a table called Sales_Orders with 2 named columns (A) Client_Name (B) Delivery_Date.
Any advice would be appreciated.
David
Hi David
Are you looking for something like this?
Please refer attachment.
SunnyKow said
Hi DavidAre you looking for something like this?
Please refer attachment.
Thanks SunnyKow,
Appreciate your help. After looking at so many examples on various web sites I became confused, but this is preciously what I am after.
Thanks again.
David
Hi David
Glad to know it helps.
Cheers
Sunny 
Hi SunnyKow,
I was just wondering if you could take another look at the file you posted for me please?
I noticed when I looked at my version earlier today that it was showing an entry that did not match the date criteria. I checked your file and noticed that there are no names listed in column D (no matches) but that the "Select a Client" validation is showing the one name "Benny". With my file, using the same formula, of the 3 possible matches it selected 2 correct and one incorrect?
I appreciate your taking the time to help.
David.
Hi David
This is due to the fact that cell J2 will retain the previous validation result and is not cleared.
You can refer here for more details https://www.myonlinetraininghub.com/clear-downstream-dependent-data-validation-lists
I have attached the updated version where the validation will be cleared and the list will not display blanks.
Hope this helps.
PS: Please use the dnlairways-4.xlsm file.
Thanks SunnyKow,
I appreciate your taking the time to help.
Sorry about the lateness of the reply, I had a few days off.
No problem
