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

Ex.

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

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!