How to compute Index Match and pull tolerance in a formula
I wonder if someone could help me to write the following formula. I have been trying for a couple of hours with no luck. I create two separate sheets
- INJ - Critical Tolerance (always fixed values - no user interaction)
- INJ - QUATO - Setup Sheet (User will specify platform and Parameter from an online form)
I want to pull the USL and LSL from the tolerance sheet and compute the results in the USL-SPEC
If Platform and Parameter match in both sheets, I want to compute the USL and LSL taking into consideration the target value in the USL-SPEC column.
Any Idea how to do that?
Your help is much appreciated!
Help Article Resources
Check out the Formula Handbook template!