Results shows #UNPARSEABLE

jackiey001

Hello!

I recently came across a very helpful answer from here: https://community.smartsheet.com/discussion/99468/if-a-value-in-a-cell-equals-the-same-value-in-a-column-from-another-sheet

I have applied the formula to my sheet, but it was returning UNPARSEABLE. I tried another column and it works fine.

Below is the value that is resulting in UNPARSEABLE

Sample Formula is =INDEX({Sheet B Column B}, MATCH([Invoice Number]@row, {Sheet B Invoice Number Column}, 0))

My Formula is =INDEX({Samples QTY to be Shipped, MATCH([Sample Type]@row, {Sample Type REF}, 0))

What is the issue here?

jackiey001

Hi all,

I just saw I left out a } hahaha....

This question is self-answered!