Help With VLOOKUP
 

This is part of a formula I am working on:

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.

This is because the OR function evaluates to: OR(TRUE,#N/A), and
therefore the final output is also "#N/A".

How can I corrct this?
--
tb

Help With VLOOKUP
 

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

Help With VLOOKUP
 

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