Hello,

I have Table1 containing a column called [Business Lines]. I have Table2 containing [Text String] and [Operating Area].

I'm trying to perform a type of Merge Query, where it will search Table1[Business Lines] for the first match of Table2[Text String] and return Table2[Operating Area].

I tried fuzzy Merge Query and it didn't function at all like I had hoped. I also came across some code online at this page: https://stackoverflow.com/questions/62327202/power-query-function-to-search-for-matching-keywords-in-a-table-of-lists-and-ret

which was very close, but also came back with Operating Areas that simply did not match. 

Any help is, of course, greatly appreciated.