Reply To: Comparing sheet data

Wow, ya’ll were on this!

Tamarin,
In Peggy’s example, the cross sheet references like {Skillable: Lab Profiles ID} would be on the “bad” sheet.

Technically we could simplify the formula and just use Match() if you don’t need to pull data back from the comparison sheet.

If there is a match the value will be a number (1 or greater)

Else it will be a #NO MATCH like the screenshots