CODEWITHSUNDEEP
excelexcel-formula
user3490883
user3490883

Reputation: 1

See if contents in one list partially matches contents in another

I'm trying to see if the contents of column B matches the contents of column A.

Column A
SULFAMETHOXAZOLE-TMP DS TABLET 500 EACH x 1
BENAZEPRIL HCL 20 MG TABLET 500 EACH x 1
AMLODIPINE BESYLATE 5 MG TAB 90 EACH x 1
ANDRODERM 4 MG/24HR PATCH 30 EACH x 1
ACYCLOVIR 800 MG TABLET 500 EACH x 1
SIMVASTATIN 10 MG TABLET 90 EACH x 1
TAMSULOSIN HCL 0.4 MG CAPSULE 100 EACH x 1
SIMVASTATIN 20 MG TABLET 90 EACH x 1

Column B
Lovastatin
Amlodipine
Glargine
Pitavastatin
Doxazosin
Tamulosin
Clindamycin
Coumadin

How do I specify a partial match?

Additionally, my data contents are huge so I need to run the match from A1:A1000 with B1:B1000, etc.

I've tried VLOOKUP, IFs formulas.

Upvotes: 0

Views: 128

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35843

As follow up from comments, next formulas works:

=ISNUMBER(MATCH("*" & B1 & "*", A:A, 0))

or

=COUNTIF(A:A, "*" & B1 & "*")>0

both returns True/False

Upvotes: 1

Related Questions