Hi
Your formula is fine. However you will need to make sure the format of the cells between the target and source sheets are the same. You could do this by copying the source sheet and then deleting all the values in the new sheet initially and then entering your formulae.
In order to stop displaying "0" if the source cell is empty simply click on the Tools Menu and select Options and untick the "Zero Values" box.
Good luck.
Tony(OTPM)