Hello,

I am trying to make a way so that the low resin column alerts you when there is low resin before you print.
Now the Resin column can have any resin name based off what someone is printing with, all the resin names are the same as a list from another tab that tracks what mL the resin is and if it is in the danger zone.
i.e. 0 = no danger, 1 = danger.

The #NAME?! is my attempt at it
Capture1.JPG

Now I want the column in the first tab to be able to match the resin in the first tab to the resin in the second tab, THEN for it to see if the column next to it is 0 or 1 and copy that.

In other words, I want it to match a specific name from resin column 1 to a list of specific names in resin column 2 then from danger column 2 to be copied to danger column 1.

Capture.JPG
Capture2.JPG

Any help is much appreciated, Thank you.