Microsoft Office Forums - View Single Post - IF statement in a CONCANTENATE function

Thread: IF statement in a CONCANTENATE function

View Single Post

Old

03-03-2020, 04:03 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows 10

Windows 10 jeffreybrown uses Office 2016

jeffreybrown uses Office 2016

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

I'm not entirely sure if you are wanting the actually food names from the dropdowns in A2 and A3, but how about...

=IFERROR(CHOOSE(MATCH(DROPDOWN,{2,3},0),"My favorite foods include tacos and FOOD1","My favorite foods include tacos and FOOD1 and FOOD2"),"")

Reply With Quote