How can I index match (if) data is not found on first sheet to go to a second sheet fo find the valu
Options
kgahm7569
✭✭✭
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
-
Resolved IFERROR --
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!