Vlookup Returns Strange Result

**ZooTV92** · 09-04-2011, 06:59 AM

I have a very straightforward vlookup formula:

=IF(AND(VLOOKUP($AB7,EmpInfo!$A$15:$AD$215,5,FALSE)<18,VLOOKUP($AB7,Summary!$A$10:$I$210,9,FALSE)>40)=FALSE,"yes","no")

that, when evaluated to the last couple of steps looks like:

if(FALSE=FALSE,"yes","no")
If(TRUE,'yes","no")

why does the result come up a zero?

The cell is not formatted specifically for anything

Thanks in advance

**martindwilson** · 09-04-2011, 07:03 AM

=IF(AND(VLOOKUP($AB7,empinfo!$A$15:$AD$215,5,FALSE)<18,VLOOKUP($AB7,summary!$A$10:$I$210,9,FALSE)>40), "yes","no")

**ZooTV92** · 09-04-2011, 07:17 AM

That was actually my original formula.

Now it comes up #N/A

How is that possible? The first condition clearly evaluates to TRUE, so the response should be "yes", right?

**martindwilson** · 09-04-2011, 07:34 AM

if either is na in an and() statement you get na

**daddylonglegs** · 09-04-2011, 07:55 AM

Try this version

=LOOKUP("zzz",IF({1,0},"yes",IF(AND(VLOOKUP($AB7,EmpInfo!$A$15:$AD$215,5,FALSE)<18,VLOOKUP($AB7, Summary!$A$10:$I$210,9,FALSE)>40 ),"no","yes")))

Then you only get "no" if both conditions are satisfied