Index/Match formula inconsistent


I have 2 simple index/match formulas to bring over information from one sheet to another. However sometimes the formula returns a #NOMATCH, seemingly dependent on how the data in the data in the other sheet is sorted? There are not parent/child rows so I don't understand why having the rows in a different order would matter? And some rows still get a match while others don't?

Here are my formulas: INDEX({Site}, MATCH(SCML@row, {SCML})) & INDEX({region}, MATCH(SCML@row, {SCML}))

Green photos are the sheet with the index formula. White is the sheet it's pulling info from


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!