I am using this formula
=IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=YES, F12/11,IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=MI XED,"ENTER",0))
in coulmn "g" and would like to know if it is possible to have another
condition added to this formula to check the next column and if true then
insert 0 . the next column would be "d"
I have tried AND plus & and several other ways but cannot seem to get the
fomrula to work.
Thank you for your assistance.
--
barry

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