Multiple IF Statements for a Range of Cells

[JubberB]

Hey! I need to write a formula for multiple IF statements that return a result after searching a range of cells. Here's what I have so far:
Data Range B2:AQ2

If any cell in the range equals any of these values, populate cell AR2 with the appropriate text

="MTG","Meeting"," "

="O","Outbound"," "

="O","Outbound"," "

="OTH","Other"," "

="PJT","Special Project"," "

="TRG","Training"," "

="V","Vacation"," "

Thank you!
JubberB

 

[JubberB]

Yes. There will be other values, but none that need to return a result. THANKS!

 

[Norie]

Try this.

1 Put MTG,O,OTH,PJT,TRG,V in A6:A11.

2 Put Meeting,Outbound,Other,Special Project,Training,Vacation in B6:B11.

3 Try this formula in AR2.

=CONCAT(IFERROR(INDEX($B$6:$B$11,MATCH(B2:AQ2, $A$6:$A$11,0)),""))

Note, I've only tested this on Excel 2019 so not sure if/how it would work in earlier versions.

Also, the ranges in 1 and 2 can be changed to suit but the need to be 2 adjacent columns.

 

[JubberB]

Sweet! Working on it now. THANK YOU!

 

[cyrilbrd]

Perhaps this will help (image Attached)


I appreciate the reply, but I don't think this is what I'm looking for. It's more like if one of the cells in the range contain a certain value, one cell contains text. Appreciate the effort, though!

So you mean to say that if one cell in the range contains MGT, you do NOT want to see Meeting in another cell?

 

[JubberB]

So you mean to say that if one cell in the range contains MGT, you do NOT want to see Meeting in another cell?

Not exactly. If the cells contain a value I specified, then the value I specified should be displayed. If it's any other value, the cell should be blank.

 

[cyrilbrd]

Not exactly. If the cells contain a value I specified, then the value I specified should be displayed. If it's any other value, the cell should be blank.

The formula of NORIE will do that and the formula I suggested as well.

 

[JubberB]

TY!

 

[JubberB]

Have you tried that?
I am still interested in the solution of Norie

I get a "?NAME" error.

 

[JubberB]

What version of excel do you have? That kind of error mostly occurs when there is a misalignment between formulas. Like if you were to type in, "Vlokup" for "Vlookup". Do you have a version of excel earlier than 2016?

Love what you did here but I cannot get it to work in Excel 2016. Only thing I can think of is I used data validation in the data range. Not sure if that matters or not. Any other thoughts? IOU at least a pint or 2!

 

[JubberB]

Are you saying there will only ever be one of the values you listed in the original post in the range?

Yes.