Hi,
I'm having difficulties in using these functions. What I want is this.
I have a list or table (text format). Then I want to check a certain cell containing a text if it is in my table then mark it as Yes or No.
So far, I got to here:
=IF(ISNA(VLOOKUP(A2,$D$2:$D$185,1,FALSE)),"No","Yes")
A2 is the cell I want to check.
D2:D185 is my lookup table.
My problem here is when the lookup_value contains two or more words. I also want it to be marked as "Yes" because it is just a sub-text. This is my example:
Lookup table/Array:
Panasonic
Asus
Intel
Now I want to check these cells:
Panasonic - Yes
Cisco - No
Asus - Yes
Asus Subcon - No <- Here's my problem, and this should be Yes because it is still Asus.
Please help me on this. i just want to use a normal excel function, not visual basic. The long method to this the IF function, is there another more shortcut method like lookup or match functions?
Thanks,
Harold
Bookmarks