tiffanyexcelhelp
New member
- Joined
- Apr 10, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
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!
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!