Vlookup to Find one value but exclude another
 

Question about the values that may be returned? Are they just numbers, such
as 17; 7; 4,7; 3,17 etc? I'm asking because typically FIND is used to find
something within a longer string (as finding 7 in 17,54).

If they are just numbers then this might work for you:
=IF(ISNA(VLOOKUP($A410,Lookup!$A:$K,9,FALSE)),"",I F(VLOOKUP($A410,Lookup!$A:$K,9,FALSE)=7,"Found 7","Not 7"))

"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