Excel Help with comparing one file to another [Closed]

Report
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
Hello,
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?


3 replies

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Patricia Banks, Good afternoon.

If the comparison is being made between different files, you have to point the names of the files in order to compare a cell from file 1 with a cell from file 2.

It is not being compared between different files. Both sets of data is in the same file on the same sheet.
Example:
=B3=L3
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?

Thank you,
Patricia
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Patricia, Good afternoon.

My suggestion to you occurred because you stated to us that you were comparing a file with another file.
"...Hello,
I am trying to see if file matches another file to make sure...
"

Suppose you know that B3 matchs L3

Try to use:

M3 --> =IF(ISNUMBER(B3),"Number","text")
N3 --> =IF(ISNUMBER(L3),"Number","text")

The results will give you the type of data being compared.

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão