IF formula returning FALSE - Help

[redrand]

I have the following formula,
=IF(Log!A:A=Sheet2!A3,IF(Log!J:J>0,"Yes","No"))

Column A in "Log" has names of Countries, in Sheet 2, cell A3, it is the name of one particular Country, in Column J in "Log" it has dates.

I simply want to match the Country name and if any dates in column J are on the same row as my Country name, the answer should be "Yes", if the cell is blank or less than 0, it should state "No".

I have tested this and it works fine, however in one workbook, it keeps returning FALSE, I have made sure I have formatted the cells via paste special, values. There should be no reason why this should not work, so obviously I am missing something silly here and not sure if anyone can help?

 

[hatstand]

Hi, If it's working fine in other workbooks. It must be the data your reading in the new workbook.

Try doing a Data / Text to Columns / Fixed Width on you data to ensure there is'nt anything hidden.

 

[redrand]

I managed to get it to work, it baffled me for some time but it turns out it was the order.

Basically the names of the Countries that I had, had to have the same order in each tab and had to start on the same row, if this did not, I got False.

Bit crazy and I am sure there is a better formula to use that will allow me to get results without having to ensure everything is mirror image.

Either way, it's working, so thanks for the advice