I’m finding this very hard to get working the way I’d like to, I’ve been trying to use a combination of ADDRESS, SUBSTITUTE, MATCH and it’s all getting a bit unwieldy.
I have two data sources that I want to compare to make sure the values are the same.
One has all numerical values in a single...