student on placement looking for assistance in formula

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.

Originally Posted by Special-K

Rule 1

Descrbe the problem, not yourself.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

I have described the problem with sample pictures, an attempt, and two descriptions of the problem I am trying to solve.
What more do you want?

You need to enclose SAFE and WARNING in quotes - that's why you are getting the #NAME error.

It is your title that Special-K was alerting you to.

Hope this helps.

Pete

fixed......?

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

Re: Post #7,

I think you would find it easier to use VLOOKUP to find the resin name (and associated properties), rather than multiple IF statements. You should note that an IF statement has 3 parts - the condition, the action_if_TRUE, and the action_if_FALSE, but your first expression:

IF('Stock Tracker WIP'!B19=G103,

only has the action_if_TRUE clause.

Also, you can't ADD (with + ) any text values - you need to use CONCATENATE ( & ) instead.

Hope this helps.

Pete