Forum Discussion
INDEX/MATCH with multiple criteria -- if value isn't found, ignore it, and search for something else
Not sure if this is possible; I have the following table. This is a dummy table but it relates to my actual in the exact same way. It's about upgrading airports; as we can see I look fo...
I will introduce another helper cell in K2 to use “Small” instead of “Small / Large” and this cell will be used in the formula for K10.
Please clarify if this statement is correct for what you want to achieve for K13
“As we can see, it yields the value of K11 if K8 does not contain the character /; otherwise it divides it by two”
or it should be the other way round.
I have attached the worksheet that shows the expected outcome, let me know if it solves the question.