I am trying to see if file matches another file to make sure the account hierarchy is correct. I have manually checked some and they are correct but I continue to get "FALSE" in the comparison section. I have used the MATCH formula and =B6=C6 formula. Do yo have any more suggestions for me?
It is not being compared between different files. Both sets of data is in the same file on the same sheet.
Same row just different column. I'm pretty sure it has something to do with format. I have cleared all formats and applied general to the entire data set. But still receive a False when I know they match.
Do you have any other ideas to try?