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
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