How to find a Partial Match within another Text Cell?

[wsamaniego]

Hi, I'm looking for a True or False response for the following scenario:
If the description in column C contains the model number from column B then the match is True. My problem is that as you can tell the Description has the full name of the model but column B has an abbreviated version "IR ADV 4545I V3" is the same as "IMAGERUNNER ADVANCE 4545I III", hence regardless of the formulas I try, my result is always false. What are my options to get the match I want?

A	B	C	D	E
1	Model	Description	Expected Match Result
2	IR ADV 4545I V3	IMAGERUNNER ADVANCE 4545I III | CASSETTE FEEDING UNIT-AN1 | INNER FINISHER-J1 | ESP NEXT GEN PCS POWER FILTER (120V/15A) XG-PCS-15D |	True
4	IR ADV C5540I V3	'IMAGERUNNER ADVANCE C5550I III | CASSETTE FEEDING UNIT-AM1 | STAPLE FINISHER-Y1 | BUFFER PASS UNIT-L1 | 2/3 HOLE PUNCHER UNIT-A1 |	False

<tbody>
</tbody>

 

[DRSteele]

Welcome to the forum.

This type of matching is tough to design in Excel. Perhaps this video about 'fuzzy lookup' from MrExcel will illuminate the concepts. [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/watch?v=IG27sqkIO8w[/FONT]

 

[wsamaniego]

Thank you! Fuzzy lookup may come in handy another time. For now I decided to just do a Left and Right trim of the model, so as to leave only the numbers that I know will always match regardless, such as 4545i or C5540i, and then look up those numbers within the description. It worked well.

Thank you again though.

 

[DRSteele]

You're welcome. I'm glad you solved your issue.

It strikes me that you just might be interested in continuous learning about Excel. I watch videos regularly from several youtube channels to which I am subscribed. The content here is all terrific! Man are there some smart cookies in the jar!


MrExcel: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/channel/UCXbicpVq_ALWG4ijPKsR7ZQ[/FONT]

ExelIsFun: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/channel/UCkndrGoNpUDV-uia6a9jwVg

most recent playlist: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/watch?v=aTe7WXEch0M&list=PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT[/FONT]

Excel Campus: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/channel/UCSxX7Vgyu9iThxPE1jSDFdw

Leila: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA[/FONT][/FONT][/FONT]<strike></strike>