IF ( OR ( AND gives #N/A

hello,

it seemed an easy question, but I don't get the answer I expect.

condition 1 : C1<2,5 and result of vlookup(...)="y"
condition 2 : C1<2 and result of vlookup(...)="n"

if condition 1 OR condition 2 -> "y"
else -> "n"

my formula:
=IF(OR(AND(C86<2,5;VLOOKUP(H86;$T$5:$U$75;2;FALSE)="y");AND(C86<2;VLOOKUP(H86;$S$5:$U$75;2;FALSE)="n"));"y";"n")

the result is #N/A.
for my pc it should be ; and not , so this is for sure correct.

Could anyone please help?
Thanks!!
Ann

the problem is because you have error value in some of the vlookup formulas.

try the below formula

Please Login or Register  to view this content.

You will get #N/A when the VLOOKUPs you are using are not able to find an exact match, i.e. H86 is not found in column T (first one) or column S (second one) - I suspect the S should be T in the second one, but I'm guessing without being able to see your workbook.

Hope this helps.

Pete

hello Tony,
thanks a lot. What a stupid mistake!
now everything works perfectly.
have a nice day
Ann

hi Pete,
this is the first time I joined a forum and I already think it super.
thanks a lot for your help!
even without my workbook you could solve it :-)
Ann

You're welcome, Ann, glad to be able to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete