Reply To: Comparing sheet data

Hi Tamarin, are the Names/Titles the same (i.e. exact match) in both sheets? if so, you can create a helper column on the sheet lacking IDs to do a formula like IndexMatch to populate the IDs from the “better page”. That’s how I would do that. There is a risk that spellings may differ, but that’s how i would take the 1st stab.

You could probably use DataMesh for which I’m not an expert.