CODEWITHSUNDEEP
exceldata-manipulation
Raj Koppula
Raj Koppula

Reputation: 1

Excel approximate matches in two columns?

I am comparing two columns with names, but the name of the columns not always uniformly in two columns(column 1 = 3M Inc and column 2 = 3M incorporate ). i used Vlookup TRUE condition but its showing several error. i am working on 50000 line items.

Vlookup with TRUE condition. Match

Upvotes: 0

Views: 1796

Answers (1)

Gangula
Gangula

Reputation: 7324

You can use a Wildcard ("*") match in the VLOOKUP formula and with FALSE condition. See the attached screenshot below.

=VLOOKUP("*"&E2&"*",$A$2:$B$7,1,FALSE)

Please checkout the Column F in the below image which looks for data in the respective cell from Column E from the Main Data.

VLOOKUP Wild card

Resources: You can check out the following video from Leila to see how the WildCard works: https://www.youtube.com/watch?v=b9WoDkPOTPs

Upvotes: 1

Related Questions