If/Or with an Index Match

@Catherine Shea I think you saying that if the Job Class = Associate, the HC Request Status should be set to Approved, but if Job Class <> Associate, run the index/match formula to pull the HC Request Status from the other sheet, yes?

You just need an IF formula, with the index/match as the "value if false" in the IF.

=IF([Job Class]@row = "Associate", "Approved", (IFERROR(INDEX({HC Request Status1}, MATCH([HC Request ID #]@row, {HC Request ID}, 0)), "")))

Logic: If Job Class is Associate, set this cell to Approved; otherwise, run this index/match formula.

Fantastic, happy to help!