# Cell value dependent on a drop down menu

1. ## Cell value dependent on a drop down menu

Greetings, Im trying to figure out how to do the following, any help would be appreciated.
Basicallt, i need to enter in a drop down menu a finished product and de-construct it into inventory needs

Cell A1 and B1 are drop down menus with the same choices. Let's say choices are 1; 2; 3 (finish product)

Cells D1 to F1 are materials

I need to return values to multiple cells depending on choice made in A1...

IE: i need +3 in D1 and + 4 in F1 if drop down =1
I need +5 in E1 and +6 in F1 if drop down =2
I need +7 in D1, +8 in E1 and +9 in F1 if drop down=3

Thanks

2. ## Re: Cell value dependent on a drop down menu

Not sure if this will work, try

in D1
=IF(A1="","",LOOKUP(A1,{1,2,3},{3,"",7}))

in E1
=IF(A1="","",LOOKUP(A1,{1,2,3},{"",5,8}))

in F1
=IF(A1="","",LOOKUP(A1,{1,2,3},{4,6,9}))

3. ## Re: Cell value dependent on a drop down menu

Formula for D1 =IF(OR(A1=1,B1=1),3,"")&IF(OR(A1=3,B1=3),7,"")

Formula for E1 =IF(OR(A1=2,B1=2),5,"")&IF(OR(A1=3,B1=3),9,"")

Formula for F1 =IF(OR(A1=1,B1=1),4,"")&IF(OR(A1=2,B1=2),6,"")&IF(OR(A1=3,B1=3),9,"")

Or

Formula for D1 =CHOOSE(A1+B1+1,"",3,"",7)

Formula for E1 =CHOOSE(A1+B1+1,"","",5,8)

Formula for F1 =CHOOSE(A1+B1+1,"",4,6,9)

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