Using an IF or Lookup Function to select something from a named list

I am working on a shipping spread sheet that involves a list of item types and UN Numbers and Hazard Classes required for shipping.

I have my Item types, Hazard Classes and UN Numbers as defined lists, so I know I can manually enter these in, however I want to create and if function (or Lookup/aggregate) that allows me to select the Item type and then the UN Number and Hazard class are auto filled.

I was initially thinking of modifying the following formula:

"=IF(J3="Rifle",IF(K3>812.8,"Yes","No"),IF(J3="Magnum",IF(K3>812.8,"Yes","No"),IF(J3="Pistol", IF(K3>457.2,"Yes","No"),"N/A")))"

However I dont think the IF function works with Named Lists etc.

Any Suggestions?