Formulas not showing results
 

Hi

My formulas does not want to work for some reason. Please help

Sonar


+-------------------------------------------------------------------+
|Filename: test3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3764 |
+-------------------------------------------------------------------+

--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=400595

Hi,

Sorry, try this one.

Regards
Sonar


+-------------------------------------------------------------------+
|Filename: test3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3766 |
+-------------------------------------------------------------------+

--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=400595

That is because the codes in sheet "Mo" are numbers and the codes in
sheet "SI-2" are not. You can easily check by using:

IF(NumberFromSheetMo=NumberFromSheetSI-2,1,0)

You will find that it returns 0. Thus they are not equal. That's why
your formula returns nothing.

To fix that, select the codes on sheet "SI-2" and go to:

Data - Text to columns - Finish


Hope it helps.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=400595