VLOOKUP Partial (Wildcard) Match question

[ssigl]

Hey everyone

I am doing a project where i need to match up company names Column A with a list of clients, column B.

Currently, I am using partial match with VLOOKUP looking like this =VLOOKUP(A1&"*",B:B,2,FALSE), but the problem is that the partial match will match Glam with with Glambo Inc.

How can i correct the formula to only turn up matches if they match the full word(s) of the lookup cell, but still allow for additional words after the matched words (e.g. Inc or Ltd?)

Any help would be very appreciated!

Thanks!

 

[Oaktree]

Welcome to the board.

Try adding a space before the wildcard.

=VLOOKUP(A1&" *",B:B,2,FALSE)

 

[ssigl]

Thanks!!

 

[ssigl]

I do have a problem though, as many of the company names have ", Inc." right after the name, which means that if i use the formula posted i will not get a match between Glam and Glam, Inc.

Not sure if there is a solution to this, but if you've got one, let me know!

Thanks again