Help With VLOOKUP

T

tb

This is part of a formula I am working on:

if(or(iserror(vlookup(a1,Exceptions!$a:$c,3,0)),vlookup(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?
 
C

Claus Busch

Hi,

Am Wed, 19 Mar 2014 20:06:48 +0000 (UTC) schrieb tb:
if(or(iserror(vlookup(a1,Exceptions!$a:$c,3,0)),vlookup(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.
 
T

tb

Hi,

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


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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top