Help with Index Match across Multiple Sheets


I need help with writing an Index / Match formula across multiple sheets. In my Remote RES sheet am trying to return the CNS No from the Engineering RES Database - SSTX sheet by Matching the SO # field. Screen shots of both sheets below.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!