Retrun a 0 instead of false with the HLOOKUP FUNCTION.

[David Brownell]

I need a little help with a function I am trying to get to return a zero value in the cell when the question asked is not "yes".
I found some help in the archives, but I'm not well versed enough to figure it out for my situation.
This is the formula I have now; =IF(AL107="YES",(HLOOKUP(AL105,Sheet2!D2:HV10,8,FALSE)))
What I would like is if I enter "no" in the AL107 cell, I want to return a "0". currently it returns "FALSE"
Thanks for your help!
Dave

 

[Fluff]

What should happen if AL107 isn't Yes or No?

 

[David Brownell]

What should happen if AL107 isn't Yes or No?

Those will be the only questions, the answering cell provides the other functions.

 

[David Brownell]

Those will be the only questions, the answering cell provides the other functions.

If it would help to simplify it further...anything other than "yes" returns a "0". the "yes" function performs as wanted.

 

[Fluff]

Ok, how about
=IF(AL107="YES",HLOOKUP(AL105,Sheet2!D2:HV10,8,FALSE),0)

 

[David Brownell]

Ok, how about
=IF(AL107="YES",HLOOKUP(AL105,Sheet2!D2:HV10,8,FALSE),0)

PERFECT! I wasn't adding a ) between the "FALSE" and "0" when I tried that earlier.
Knew it should be quite simple.
Thanks so much!

 

[Fluff]

You're welcome & thanks for the feedback.