Before jumping to VBA you should try replacing all the IFs in that formula with something like VLOOKUP or INDEX/MATCH.

Perhaps something like this.
Formula: copy to clipboard
=IFERROR(INDEX(L4:L36, MATCH(E4,M4:M36,0)), "")


PS That's Scottish.