CODEWITHSUNDEEP
excelcompare
TSL2025
TSL2025

Reputation: 1

Compare name from column A to anywhere from column B, Google Sheet or Excel

I would like to know if it is possible to compare column A to column B to find matches or similar entry. For example,

A B
Gin, Hendricks A. Mountain, Dew Beta
Mountain, Dew B. Gin, Hendricks Alpha

It should detect whether colum A have similar or exact data from any row in column B.

Upvotes: -5

Views: 63

Answers (1)

Mark S.
Mark S.

Reputation: 2596

=vlookup(A1, B:B,1,0) will return #N/A when there is no match.

=xlookup(A1, B:B,B:B, "No Match",0) will return "no match" when there isn't one.

To change either of these to non-exact match it would read:

=vlookup(A1, B:B,1,1)

=xlookup(A1, B:B,B:B, "No Match",1) you can alternate -1 or 2 depending on the need.

Upvotes: 0

Related Questions