Help with Conditional Index Match



  1. I have a sheet titled Copy/Paste Data with a column that has multiple text values.
  2. I have another sheet titled 23-24 Status.

I am trying to conduct an index match on sheet titled Copy/Paste Data when a specific column within this sheet contain the text SNP but keep getting #UNPARSEABLE error.

=IF({Copy/Paste Data Range 1}) = "SNP", INDEX({Copy/Paste Data Range 2}, MATCH(CEID@row, {Copy/Paste Data Range 3}, 0))

All assistance is greatly appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!