IF statement in a CONCANTENATE function

		Microsoft Office Forums > Microsoft Excel > Excel
IF statement in a CONCANTENATE function

FAQ

Thread Tools

Display Modes

03-03-2020, 04:03 PM

jeffreybrown jeffreybrown is offline

Windows 10 IF statement in a CONCANTENATE function

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

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"),"")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting a Select statement in Excel to an update statement	shabbaranks	Excel Programming	5	10-31-2018 11:47 PM
WEEKNUM function not adhering to the IF statement	darkoman	Excel	1	06-09-2016 06:28 AM
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
concantenate cells in multiple row	shilabrow	Excel	7	03-26-2015 06:42 PM
Mail Merge Function not Noticing 'True' vs. 'False' Statement	danellekent	Mail Merge	1	04-27-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:10 AM.