Which function to use

Using  - Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit

I have a list of trucks, their size in cubes, and weight in pounds.

I would like to create a template where I can drop that info (changes each day) and have a column that sorts them:

van a - under 6000 lbs

van b - under 4000 lbs

28 ft - over 4000 lbs, under 650 cube

36 ft - under 850 cube

48 ft - under 1350 cube

How could I do this? Where it references the cell and chooses an option above based on the ranges between different vehicles?