Index Match help
I am trying to convert from Excel to Smartsheet without adding a ton of columns to make this work. I am not if Index/Match is the way to go OR VLOOKUP, etc.
Again, the entries from the operators will vary therefore the low/high specs are used in previous columns that you helped me with.
This is the excel version of ONE stage. As you can see the formulas were added below in the form of "IF" functions. If the entry is above the spec, "HIGH", etc. The row below is set to do a Vlookup on another tab with the following information:
Based on 3 column, if low/high/okay for each cell and then return a required action based on the combination of these three cells.
Is it possible to somehow create this in one column or even 2 and cross-reference another sheet?
Currently have the following for conditional formatting (on a previous thread).
Help Article Resources
Check out the Formula Handbook template!