Formula Help

I am using an index & match formula to cross reference another sheet for data plugins. My problem is some of the data that I need is coming back as a #NO MATCH which is understandable because some of the information is not available. There are other sheets that do have the same criteria available that I can match too but I'm unsure how to set the formula to find it. if it doesn't find it on the first sheet then it will need to look on the second and third sheet. My original formula is this.

=INDEX({Raw Material name}, MATCH([RAW MATERIAL ID]@row, {Raw Material Inventory Range 1}, 0))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!