On 3/19/2014 at 3:23:38 PM Claus Busch wrote:

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,Exception
s!$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.

Thanks!

--
tb