Data Validation Equals a Pass/Fail

Andrea Knoper
New Contributor

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? 


Gloss Data.PNG

6 Replies

Hi @Andrea Knoper


Could you provide an example,  it's not clear what you are referring to in terms of "data" and "value", or what sort of association with the Part Number you need





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. 

Hi @Andrea Knoper


Do you need something like the attached file?



if you have a seperate table to define the pass status of a product number for DELTA and MAX you can use LOOKUP, VLOOKUP, HLOOKUP formulas to import this data to your main table.

Yes. Something like that would work! 

Ok. I can try that too. Thank you! 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies