hello all, I sure hope someone has a bigger brain than I do, because I've been slamming my head against my desk all day with this.



in A1, I have a drop down with "2,3" in it. the cell is named DROPDOWN
in A2, I have a drop down with "pizza,sushi" in it. this cell is named FOOD1
in A3, I have a drop down with "pizza,sushi" in it. this cell is named FOOD3

I think have a CONCANTENATE function in B5 that starts "My favorite foods include tacos"

then, i'm trying to include 2 IF statements.
IF(DROPDOWN>=2, "and ",FOOD1," ","")
IF(DROPDOWN>=3, "and ",FOOD2," ","")

the ideas is that if the number 2 is selected in DROPDOWN, it reads "My favorite foods include tacos and FOOD1", and if the number 3 is selected in DROPDOWN, the output of B5 reads "My favorite foods include tacos and FOOD1 and FOOD2"


this is what is in B5, and what is not working

=CONCATENATE("My favorite foods include tacos",=IF(DROPDOWN>=2, "and ",FOOD1," ","") ",=IF(DROPDOWN>=3, "and ",FOOD2," ","")")

this is a silly example of something I'm trying to do for a work document, where macros are not allowed. Any help would be greatly appreciated!

Attached Files

dropdownexample.xlsx (8.5 KB, 9 views)