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