Vlookup to Find one value but exclude another
 

Try this...

Just I am giving you the below formula upto my knowledge...

=IF(VLOOKUP($A410,Lookup!$A:$K,9,FALSE)=7,"YES","N O")

The above formula will give the desired result, but if suppose the value you
are looking in that particular range is not available then the formula will
result N/A. I dont know how to make a comment for that in the if statement.
But it can be done by using ISNA function.

Some experts will see and give solution for this.

--------------------
(MS-Exl-Learner)
--------------------



"Sarah (OGI)" wrote:

I have the following formula:

=IF(COUNT(FIND(7,VLOOKUP($A410,Lookup!$A:$K,9,FALS E))),"Yes","No")

If the result of the vlookup finds a "7", the returned value will show
"Yes", but how can I exclude something like "17". The values that I'm
looking through might show "7", "4,7", "3,17", etc and what I want is, if the
value contains the number 7 (but not 17, 27, 37, or whatever it might be), I
want to see a returned value of "Yes".

I hope that makes sense and that someone can help.

Thanks