Try to use Iserror function .....

=IF(ISERROR(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FAL SE)),IF(ISERROR(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2 ,FALSE)),0,"ENTER"),
F12/11)))


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98307