Assign group name to a list of values within another column

Thanks for taking a look

I need a mapping formula to add to column E

- map values in column A to column C names
- column E add above mapping formula, which reads column F

Please ignore the ticket and detail values.

Thanks