Forum Discussion

u234l530's avatar
u234l530
Copper Contributor
Oct 27, 2023

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:

Workbook One Drive

  • u234l530 

     

    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).

     

     

  • rachel's avatar
    rachel
    Steel Contributor

    u234l530 

     

    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).

     

     

    • u234l530's avatar
      u234l530
      Copper Contributor

      rachel HI Rachel, Thank you for the solution. the Column K formula stays the same right? i have over hundred clients do I pu down the fomula and it shall work same way?

       

      Appreciate the help

       

      • rachel's avatar
        rachel
        Steel Contributor
        Hi,

        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.

Resources