Using If and Index Match across multiple sheets


I had to break down two cross sheets due to the size of data. I created another sheet with a form. I would like to have an index match formula that if a name was found at the row, it would cross-reference the sheet tied to where that data is store and return a value. This would eliminate the need to pivot into that data sheet and manually enter the information. Note that I cannot link the cells, as original sheets are updated with data shuttle.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!