looking for a Power Querry version of this Wild card formula used in Excel.

[acorleto]

IFERROR(VLOOKUP("*"&A7&"*",'[PIP Connection_.xlsb]Comments for Crew check'!$B:$C,2,0),"No")
(A7 is n order) looking for a match inside a group of comments)
works in Excel but not so much in P.Q Help much appreciated. Thank you

 

[GraH]

In PQ you do not use lookup formulae, but you resort to a merge query with any of the available join types. Fuzzy match is an option you can flag, however it is recommended since it is costly on the performance site.
Also .XLSB is not the preferred Excel extension for PQ. It is slow, slower, slowest.
In PQ the preferred option would be to split the comment in words. Ths would give a list. Then use a List.Intersect(ListFromText,ListOfOrders) to find the orders inside the text. Then expand this last list.
Depending on the pattern, one would need to clean up the listFromText first. Removing uppercase or not; removing punctuations, etc.