Index Match issue on Contact column

My index match fx (in the left destination sheet) is populating with names found in the match but they're not functioning as contacts when linked in- how would I do this properly?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!