Populate cell based on choices from a drop down menu"

[Marq]

using 365

I have a drop down menu in cell B6. I want to populate cell E29 with an X based on a choice I make in B6 drop down.

Multiple choices from the B6 drop down list can give me an X in E29 and I have a formula working in E29 that gives me an X based on one of the choices.....how do I make E29 populate with an X if I chose a different choice in B6 drop down?

Here is my formula in E29 working with one choice: =IF($B$6="Cart 1 (hot)","X","") So this is saying leave E29 blank UNLESS I choose Cart 1 (hot) from B6 drop down...and if I do chose it, put an X in E29.


But I also need an X to show in E29 if I choose Cart 2 (hot) in B6 drop down.

How do I incorporate that cart 2 hot into the formula? I tried this but E29 populates as FALSE : =IF($B$6="Cart 1 (hot)",IF($B$6="Cart 2 (hot)","X",""))

Why is the formula not working???

 

[Toadstool]

Hi Marq,

IF statements have 3 parts: Test, result if TRUE, result if FALSE
Your statement checks for Cart 1 and if true then checks for Cart 2, which makes no sense. Also it doesn't have a FALSE option for Cart 1 so that will show the logical result, FALSE.

If you have several options to populate in E29 then I suggest a lookup based on which B6 option is selected, like this:

Marq2.xlsx
	B	C	D	E	F	G	H	I	J	K
1									Cart	Populate
2									Cart 1	X
3									Cart 2	X
4									Cart 3	N
5									Cart 4	T
6	Cart 3								Cart 5	X
7
28
29				N
Sheet1

Cell Formulas
Range	Formula
E29	E29	=VLOOKUP($B$6,$J$2:$K$6,2,0)

Cells with Data Validation
Cell	Allow	Criteria
B6	List	=$J$2:$J$6

 

[aghaffar82]

And if you want to remain stuck with IF function, try this:

=IF($B$6="Cart 1 (hot)","X",IF($B$6="Cart 2 (hot)","X",""))

Copy this part before the last comma and replace your criteria for the remaining conditions one by one.

,IF($B$6="Cart 2 (hot)","X"

 

[Marq]

And if you want to remain stuck with IF function, try this:

=IF($B$6="Cart 1 (hot)","X",IF($B$6="Cart 2 (hot)","X",""))

Copy this part before the last comma and replace your criteria for the remaining conditions one by one.

,IF($B$6="Cart 2 (hot)","X"

That works..thanks!

Thanks to everyone that chimed in!

 

[aghaffar82]

Thanks for the feedback. Glad to assist you