Hello. I am looking to revamp a data sheet to associate values with a drop-down and I am unsure how to formulate it...
This data sheet will have information added every day and also needs to be searchable. So I have turned it to a table already. It needs to give a pass or fail outcome for 2 pieces of data ("Max" and "Delta"). The data has to be less than or equal to a certain value. This value now needs to be associated to a number from a validation list which I have added to the "Part Number" column. How do I associate that part number with the Max and Delta pass/fail?
Specifically... I need a user to be able to input stuff into each column. They need to be able to choose a "part number". Based on that part number, they have a certain "Max" and "Delta" that it has to meet. That max and delta both have to be a "pass". Then they can pass that part number. If it is a fail, they need to take further action.
Each part number will have different max and deltas to meet. I just need to associate it somehow. If that is possible.