vlookup - Match partial string

[carlrover]

Found a few things on here that I thought might do the trick, but haven't been able to find anything that actually works for what I need, so any help would be greatly appreciated!

I am trying to match a part of string using Vlookup to an array of known normalized values.

For example, I have a set of cells with strings like:

Short Description	#1	#2
[XYZ] [HBDG843] Text Option Alpha Blue dw.23948532 (ewa90qnvwierfn)
[ABC] - WEX12>WEZ13 GB.2345345239 Text Option Delta Green 4334qte
[MNO] [something] 345rqre Text Option Charlie Grey tq34ttt-4q3tsdd

<tbody>
</tbody>

The array would be something like this:

Normalized Description	#1	#2
Text Option Alpha Blue	4.5	2.3
Text Option Delta Green	1.2	2.1
Text Option Charlie Grey	3.4	2.7

<tbody>
</tbody>

I would like to match the Short Description to the Normalized Short Description, but everything I have seen seems to work the other way around, which is not what I want.

Any ideas?

Thanks!