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?

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Model[/TD]
[TD]Description[/TD]
[TD]Expected Match Result[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]IR ADV 4545I V3[/TD]
[TD]IMAGERUNNER ADVANCE 4545I III |
CASSETTE FEEDING UNIT-AN1 |
INNER FINISHER-J1 |
ESP NEXT GEN PCS POWER FILTER (120V/15A) XG-PCS-15D |
[/TD]
[TD]True[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]IR ADV C5540I V3[/TD]
[TD]'IMAGERUNNER ADVANCE C5550I III |
CASSETTE FEEDING UNIT-AM1 |
STAPLE FINISHER-Y1 |
BUFFER PASS UNIT-L1 |
2/3 HOLE PUNCHER UNIT-A1 |
[/TD]
[TD]False[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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>