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

 

[SteveOranjinSteve]

My understanding is that this is the PRE "IFS" way to do it.

=IF(B2:AQ2="MTG","Meetings",IF(B2:AQ2="O","Outbound"),IF(B2:AQ2="OTH","Other",IF(B2:AQ2="PJT","Special Project",IF(B2:AQ2="TRG","Training",IF(B2:AQ2="V","Vacation","No Values Provided")))))

But again, if you want a list of comma seperated values of each value that appears if there are more than one, than you are out of luck with this formula.

 

[JubberB]

My understanding is that this is the PRE "IFS" way to do it.

=IF(B2:AQ2="MTG","Meetings",IF(B2:AQ2="O","Outbound"),IF(B2:AQ2="OTH","Other",IF(B2:AQ2="PJT","Special Project",IF(B2:AQ2="TRG","Training",IF(B2:AQ2="V","Vacation","No Values Provided")))))

But again, if you want a list of comma seperated values of each value that appears if there are more than one, than you are out of luck with this formula.

Understood. I will have other values in the cell range, but they require no action / result. I will only have one of the values in the formula that requires and action / result. So, if one of the values appears in the cell rage, I need the corresponding result to appear in the target cell.
Thanks,
JohnB

 

[SteveOranjinSteve]

Then you will need to remove those values. This is probably not the best way to do it. This will look at all the value, find the first cell that contains one of those values, and then trigger the corresponding result.

I don't know the other way. Some of the other guys on this forum are really good though, if you ask your question clearly I imagine one of them will swoop down and answer for you.

 

[JubberB]

I appreciate your effort!