#NOMATCH Error

System

This discussion was created from comments split from: Does INDEX(MATCH) work on a column with a formula?.

BB2791

Hi @Kelly Moore

Just updating that formula in the target sheet worked! I didn't realize it was the concatenated string that was causing the issue. I also have updated the form fields on the source sheet so it's no longer "Full Name" but mirrors the 3 fields on the target sheet.

Thank you so much for your help with this!