Hello, I am trying to create an index/match function but am receiving a #NO MATCH even though I know the value is in the reference range and I am almost positive my formula is correct.
=IF(INDEX({RPA Action}, MATCH([Row ID]@row, {RPA ID}, 0)) = "New Appointment - new to UNCH", "NEW HIRE REPLACEMENT", " ") MARLANA KALINOWSKI Sr. Business Analysts / Smartsheet Solutions National Pharmacy Services |Genoa Healthcare ...