# Select toy and quantity

1. ## Select toy and quantity

Hello Forum,
My kid has 4 sets amount of money and has 3 types of toy to choose.

If the amount of money is 8 and he selects toy A he can have 1 to 8 toys
If the amount of money is 8 and he selects toy B he can have 1 to 4 toys
If the amount of money is 8 and he selects toy C he can have 1 to 2 toys
And so on
I can make the dropdown list in G2, G5, G8, & G11 to select the toy but cannot make the
dropdown in H2, H5, H8, H11 to work with the QTY in column E
How can I create the dropdown lists in column H to select the QTY
Kidprojects

2. ## Re: Select toy and quantity

O1: QTY
O2:O33 - 1,2,3,4,5,6,7,8,9,10,11.......32

2) Temporarily select "A" in G2

3) Add Data Validation to H2:
Allow: List
Source: =OFFSET(\$O\$2, , , B3/VLOOKUP(G2, C2:D4, 2, 0), )

4) Copy H2 and paste over the other gray cells

3. ## Re: Select toy and quantity

Hi Jerry,
It works perfectly. Is there a way to make it works when I move the dropdown lists to another sheet so it look cleaner?
Thank you so much for your help
Kidprojects

4. ## Re: Select toy and quantity

I've highlighted the cell in the formula above you would need to update to point the cell that has the "1" in your QTY list.

5. ## Re: Select toy and quantity

It works! Thank you Jerry.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1