Nested IFs Excel - Alternative

I have a large data set with multiple columns - each row has a case type and a contract value. On another sheet I have a mapping table (shown below) of case types and value ranges that decide what "Type" each row should be assigned too.

For example a row with case type 1 and a contract value of $20,000,000 would be type 1 - a row with Case type 3 with a value of $4,000,000 would be Type 3 as it falls between the value ranges for type 3 (N4 and O4)

I know I could hardcode an IF statement in 14 helper columns to fulfill for each Case Type and then combine cells that aren't blank but I'd love to know is there a smarter way of doing this?