Hi.....I work quality control and would like to see the data "Pass" or "Fail" based upon specification data.
The worksheet that I enter data has several columns
Product # / Factory / Weight / Length / Width / Palm Thickness / Finger Thickness
I would like to add columns next to each that display "Pass" or "Fail" based upon what I measure.
Another worksheet in this file contains the Factory Specifications. It just lists the different factories in a table with product numbers and what the measurements should be. One product number can have up to four different factories, all with slightly different specifications.
I wrote a good VLOOKUP formula for a specific variable(i.e. "Length"), but I cannot figure out how to write a formula that will change with varying factories for the same product numbers.
Any assistance would be hugely appreciated!......this is my first real post....and not too sure if this is very clear.....so please let me know if there is further clarification needed.
Bookmarks