Get value from another sheet based on value from source sheet


I am trying to get the proper or most efficient syntax to take a Contact Name from a source sheet and match the value in a second sheet to then bring back a value from the matching row.

I am attaching a screenshot. Looking for accurate syntax of current function or better function.

Function being used =IFERROR(INDEX({​​​​​​​​LO_Email Contact Name}​​​​​​​​, MATCH([Assigned To]@row, {LO_Email ​​​​​​​​Contact email}​​​​​​​​, 0)), "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!