How can I index match (if) data is not found on first sheet to go to a second sheet fo find the valu



index (Code), match (EID@Row), sheet 1 EID

But if ot found there I want it to look at sheet 2 for EID


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!