Forum Discussion
u234l530
Oct 27, 2023Copper Contributor
Dropdown List to return a unique value
Please help me with my workbook as Iam novice to Excel.
I have 2 sheets, "STOCKS" and "ORDERLIST" .....I want to automate in Allocation Column the email address of the client matching the criteria of Product_Name,Size and Gender. its should return the email address as unique value, is drop down list possible? as it will facilitate me to choose whom to send. whatever is possible please help me with this formulae.
Thanks
Files below:
Hi,
I use TRANSPOSE + FILTER function to filter out client emails.
Then I put =$K2# in the data validation list for the drop down. so now you can choose which email to send.
(I attached the excel INV Mngmt_dropdownlist.xlsx here).
- rachelSteel Contributor
Hi,
I use TRANSPOSE + FILTER function to filter out client emails.
Then I put =$K2# in the data validation list for the drop down. so now you can choose which email to send.
(I attached the excel INV Mngmt_dropdownlist.xlsx here).
- rachelSteel ContributorHi,
You can put bellow in cell K2.
=IFERROR(TRANSPOSE(INDEX(FILTER(Table1,(Table1[Product_Name]=Table2[@[Product_Name]])*(Table1[Size]=Table2[@Size])*(Table1[Gender]=Table2[@Gender])),,MATCH(Table1[[#Headers],[Email]],Table1[#Headers],0))),"")
Then you can just pull down the formula. it shall work.