This has been working very well on previous sheets. This is a Titration Log and it varies per plant and therefore very tailored to their line and parameters. In the steel business - so you'll see substrate as to what I am matching.
I have a column that does the look up and returns "red" if out of spec. The ALUM formula is not working.
=IF(ISBLANK([Stage 8 FA]@row), "", IF(OR([Stage 8 FA]@row < INDEX({S8FA Low}, MATCH(Substrate@row, {SUBST}, 1)), [Stage 8 FA]@row > INDEX({S8FA High}, MATCH(Substrate@row, {SUBST}, 1))), "Red"))
This is the sheet it uses to look at the specs (INDEX):
Help :)
Thanks!!!