Results 1 to 4 of 4

Thread: Using Drop Down to Populate Multiple Cell Values from Different Sheet

  1. #1

    Using Drop Down to Populate Multiple Cell Values from Different Sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello!
    I'm trying to use a drop down item list located on my first sheet: it's a drop down of product item sizes (64oz, 7oz, 5.5oz). I have a table (A12:B38) in my second sheet that has the product item size in Column A, and the flavors in Column B. (Example: Row12 Column A: 7oz, Row 12 Column B: Grapefruit. Row 13 Column A: 7oz, Row 13 Column B: Pineapple and so on.)

    I want to be able to choose an item size from the dropdown in Sheet 1, and have the flavors appear below depending on my choice. (flavor data from Sheet 2)

    I've looked online for hours but I'm completely stumped. I had a great picture to attach here, but I don't have enough posts for it because I'm new. I'm hoping this is possible with a formula. I don't know much about macros. If anyone can help with this I'd be forever thankful!!!

    THANKS!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ExcelHelp.png 
Views:	25 
Size:	62.9 KB 
ID:	3377  

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the file. Is it help you ?
    Attached Files Attached Files

  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Try to copy the unique data, then count them on Sheet1.

    In cell F3 on Sheet1 and copy down
    Code:
    =COUNTIF(A$3:A3;A3)

    In cell G3 on Sheet1 put ARRAY formula and copy down (finish formula with Ctrl+Shift+Enter)
    Code:
    =IFERROR(INDEX($A$3:$A$30;SMALL(IF($F$3:$F$30=1;ROW($A$3:$A$30)-ROW($A$3)+1);ROWS($A$3:$A3)));"")
    Select range G3:G30 and define name uniqueData
    On Sheet2 in Validation List put =uniqueData

    if not working formulas, replace the comma with a semicolon

  4. #4
    worked like a charm!!

    Thank you so much Appreciate it!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •