11 Responses to “Use a drop down list to search and return multiple values”

1. Ainslie Says:
   December 7th, 2011 at 8:28 pm
   
   

   thank you so much!!! Worked Perfectly

2. Rattan Says:
   December 27th, 2011 at 3:05 pm
   
   

   For some reason I am unable to 'ask a question' by clicking the link, so, I thought i'll post it here since it is relevant to drop-down list.

   In my workbook I have three worksheets; "Customer", "Vendor" and "Payment". In the Customer sheet I have a table, tblCustomer, where I add new customers. Similarly, in the Vendor sheet I have a table, tblVendor, where I add new vendors. In the Payment sheet I have a table, tblPayment, where i have three columns; Date, Amount and Name. Now, here is what I want to do; In the Name column of the tblPayment, I want to create a drop down list in each cell, which would contain all the names from tblCustomer[Name] and tblVendor[Name]. This way I can fill in the Date, Amount and then select one of all the names available in the drop down list of my Name cell. Is this possible without using VB code or any macro? If so, please help me out with this.

3. Oscar Says:
   January 2nd, 2012 at 4:49 pm
   
   

   Rattan,

   Read this post: Basic invoice template in excel

4. abdussamed Says:
   January 20th, 2012 at 9:17 am
   
   

   Pls the best way excel functions espeacially VLOOKUP / HLOOKUP etc to use in various way , columns, functions, multiple way.

   rgds

   abdussamed

5. Aynsley Wall Says:
   March 12th, 2012 at 4:25 pm
   
   

   Hi, I know this isn't array formula but maybe you can still help me. I have a spreadsheet that I use for 3 different companies.
   What i would really like to do is have a drop down menu with the three company names: eg: Mcdonalds, Pizza Hut, Subway and then when i choose which company the spreadsheet will be for then all the contact information and logo will appear as a header on the top of the spread sheet. is this possible?

6. Ainslie Says:
   March 15th, 2012 at 7:04 pm
   
   

   Hi one more question this array formula that you gave me earlier in the year, it's not working now.
   I added another drop down box right beside the first one and i just want to take the exact same informaion so i dragged the formula to copy into the other cells and i just changed from B26 to B27 where the drop down menu is to look up.
   Now it is not getting any of my informaion even though it's the exact same formula

7. Oscar Says:
   March 15th, 2012 at 9:16 pm
   
   

   Ainslie,

   Can you provide both formulas? I am not sure whats wrong.

8. Ainslie Says:
   March 15th, 2012 at 9:27 pm
   
   

   This is the original:
   =IFERROR(INDEX(Panels!$C$2:$C$80, SMALL(IF($B$56=Panels!$A$2:$A$80, MATCH(ROW(Panels!$A$2:$A$80), ROW(Panels!$A$2:$A$80)), ""), ROW(A1))), "")

   This is the one i'm trying to get to work. I need it to do the exact same thing in cells below where the original is used but both need to do the same thing just the drop down box where it has the information where to lookup is in a different location

   =IFERROR(INDEX(Panels!$C$2:$C$80, SMALL(IF($B$57=Panels!$A$2:$A$80, MATCH(ROW(Panels!$A$2:$A$80), ROW(Panels!$A$2:$A$80)), ""), ROW(A1))), "")

9. Oscar Says:
   March 16th, 2012 at 4:04 pm
   
   

   Ainslie,

   There seems to be nothing wrong with the formulas. Maybe the value ($B$57) in the drop down list doesnt exactly match some of the values in your list (Panels!$A$2:$A$80)?

10. Ainslie Says:
    March 16th, 2012 at 4:28 pm
    
    

    nope, that's all the same, nothing has changed. it works in the other drop down box in B56 - the exact same values but not in B57

11. Oscar Says:
    March 21st, 2012 at 10:02 am
    
    

    Aynsley Wall,

    See this post: Use a drop down list to select company info in header (vba)

Leave a Reply