IF function "True" not recognizing numbers

[Danook]

I am working in two different files. If number "40556" on worksheet B is showing on worksheet A, the function is to state "TRUE", but it's stating "FALSE". Both files' numbers are listed as GENERAL under FORMAT CELLS. Please help!

[Special-K]

Trailing spaces? Use TRIM or LEN to verify there is ONLY 5 characters in the cell containing 40556

[Danook]

Special-K, I tested and there are only 5 characters.

[daddylonglegs]

Which function are you using?

Just because the format says "general" doesn't mean the cells are formatted the same. Check the two "matching" cells using the formula

=ISNUMBER(cell)

[replace "cell" with the relevant cell reference]. They both need to be TRUE (or both FALSE) otherwise you have a "data mismatch"

[Danook]

I am using the "IF" function. I am comparing numbers in two different files.

[daddylonglegs]

Ok so assume you are using

=IF(Sheet1!A1=Sheet2!B2,TRUE,FALSE)

what do you get if you try

=IF(Sheet1!A1+0=Sheet2!B2+0,TRUE,FALSE)

[Danook]

I tried and it's not working. This is frustrating as I use the IF function all the time.

[daddylonglegs]

Can you post the workbook or a sample that shows the formulas that don't work?

[Danook]

Here are the two files I'm working on. The IF function is in the CDM file.

[Danook]

I didn't post the attachments correctly. I will re-post in a few. Sorry!

[Danook]

Okay, here's the correct files. The IF function is in the CDM file.

[daddylonglegs]

I don't see anything wrong. You are comparing each cell in A2:A10 in CDM file to a single cell, A2, in the other file.....only one of them matches so you get one TRUE, in C6.

Do you mean to compare each value in A2:A10 CDM to all the values in A2:A10 in the other file? If so you need to use MATCH like this in C2 copied down

=IF(ISNUMBER(MATCH(A2,'[Grouped%20Charge%20Codes(1).xls]Sheet1'!$A$2:$A$10,0)),TRUE,FALSE)

Note: that's how the workbook name came out when I opened it, you probably need to amend it in your formula......

[Danook]

You are exactly right! Thank you so much!