Excel Help with comparing one file to another

Closed
Patricia Banks - May 25, 2017 at 11:05 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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?


3 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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.
0
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
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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
0