Help with nested IFERROR using INDEX/MATCH - unparseable

TSmith72

I am trying to return a value to a destination sheet from multiple cross referenced sheets if it exists in one or multiples of those sheets. The following formula returns unparseable - and I'm not sure what I'm doing wrong. Admittedly I am a smartsheet novice.

Thanks for any help in advance.

=IFERROR(INDEX({tab_case_inv_qu_id}, MATCH([Question Name]@row, {tab_case_inv_qu_name}, 0)), "") & "|" & IFERROR(INDEX({tab_patient_case_qu_id}, MATCH([Question Name]@row, {tab_patient_case_qu_lbl},0)), "")

Jennifer Kurtz

Hi @TSmith72 - I think all you may need to do is change your '&' to '+'

=IFERROR(INDEX({tab_case_inv_qu_id}, MATCH([Question Name]@row, {tab_case_inv_qu_name}, 0)), "") + "|" + IFERROR(INDEX({tab_patient_case_qu_id}, MATCH([Question Name]@row, {tab_patient_case_qu_lbl},0)), "")

Does that work for you?