Hi. There are two sheets with similar data, but the data may be on different rows. The data in columns A,B,C,D are always the same and accurate, albeit possibly on different rows on the two sheets. The data in column E may be different or blank, though. But it shouldn't be.
What might be the best way to compare the concatenation of A&B&C&D with the values in column E? I'm thinking it would be an Index or Match or SumProduct formula, or a combination of them, but I cannot think of how best to go about this. Any help or advice would be greatly appreciated. Thanks!
Frank
Bookmarks