Return a value based on two criteria.
Hello Smartsheet Community!
First time posting a questions so here goes....
I need some assistance and am stuck with a formula. I have a Master File that looks at a lookup file for data.
I have Customer ID that have a Tier I rate and a Tier II rate based on a location. I already have in my file what Tier is expected but am having trouble bringing in the Max rate. I need to bring in the Tier Max Rate for that customer Tier so I can leverage a column that determines whether the requested rate is in under the Tier Max or not to see approval to proceed.
Each Picture is a separate sheet so the first picture would look at the second picture.
Any assistance would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!