Excel Help with comparing one file to another

Closed
Patricia Banks - May 25, 2017 at 11:05 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 25, 2017 at 04:17 PM
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?


Related:

3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 25, 2017 at 02:38 PM
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.
Patricia Banks
May 25, 2017 at 04:05 PM
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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 25, 2017 at 04:17 PM
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