Need help creating a formula in excel

[JoeJr382018]

I need help creating a formula at incorporates the info in the list below the main table in the image above. Thanks

[#2 · Accepted solution]

You may use this formula in H4:
=IF(B4=“Empty”,O$4,
IF(B4=“Loaded”, LOOKUP(F4,M$8:M$12,O$8:O$12),
“”))

[#3]

Thanks that worked perfectly

[#4]

It pleases me to know that!