I have multiple relationships, in total about 8-9 tabs of tables of data - but Im getting an issue related to text function.
One tab has a column with 70% of data by name and rest blank, and I want to compare it to current HC to see which names are the same. Similar to how VLOOKUP used to or an IF, but for some reason I can't link between these tables, any ideas why?