Lookup partial Value

Hello everyone,

i am in need of some help to optimize a formula.

In worksheet "GL-EXIT DOOR - ARENA Plaza" in cell D14, i am looking to optimize it.

at the moment the formula takes the content in C 15 and compares it with "Lookup Table " worksheet in Position and places content of C3.

if any of the key words are not found then the default value is assigned.

is there anything that can be done to make the formula cleaner?

Thank you for any assistance.