Hi,

Am Wed, 19 Mar 2014 20:06:48 +0000 (UTC) schrieb tb:

if(or(iserror(vlookup(a1,Exceptions!$a:$c,3,0)),vl ookup(a1,Exceptions!$a
:$c,3,0)=""),"Do step A","Do step B")

The formula does not evaluate correctly with the second VLOOKUP when
the value in A1 is not present in the Exceptions tab.

try:
=IF(ISERROR(VLOOKUP(A1,Exeptions!A:C,3,0)),"Do step A",IF(VLOOKUP(A1,Exeptions!A:C,3,0)=0,"Do step A","Do step B"))


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional