Hi,
I’m having a problem with the following formula:
=IF(VLOOKUP(A2,list!$K$2:$M$10,3,FALSE)=”x”,”yes”,”no”)
It is giving a result of “yes” if the vlookup is an “x”, however all my other values show up as #N/A, as opposed to my expectations of it being a “no” (as this is the “otherwise” part of the formula). I’ve tried playing around with my parenthesis, but have had no success. Anyone know what I’m doing wrong?
Thanks!
Lana