How to look up a partial string using either Xlookup or Power Query

Hi,   I'm wondering if it's possible to use Xlookup or Power Query to do a partial match from a table of possible matches.   For example: In the image below I'm trying to lookup the prices on eac...