CODEWITHSUNDEEP
excelexcel-formulavlookup
Not Sure
Not Sure

Reputation: 37

Vlookup with Wild card {*} in excel

I have the below table:

enter image description here

Now, I want to check if the subject is having any of the text present in data (col F)

I used:-

=VLOOKUP(A2&"*",F:F,1,0)

But it is giving #N/A.

Upvotes: 0

Views: 333

Answers (1)

JvdV
JvdV

Reputation: 75840

Try:

enter image description here

Formula in B2:

=SUM(COUNTIF(A2,F$2:F$3&"*"))>0

Edit:

=SUM(COUNTIF(A2,F$2:INDEX(F:F,MATCH("ZZZ",F:F))&"*"))>0

Upvotes: 1

Related Questions