Hello

I'm looking for a pre defined value to be returned when the selections in K10 & L10 match the combination from the range AB8:AB23 and AC8:AC23.

I previously tried a IF & statement but there are too many conditions for it to work.

Any advice would be greatly appreciated for a newcomer Issue Log.xlsx

Formula.PNG