Lookup value based on multiple criteria where one is searching a cell for specific text string

[alex0182828]

I need to change the below forumla so instead of checking if there are any cells in order_adjustment!G:G that equal "Added Manually" so that it checks if they contain the text string "Added Manually"

The Cell AM5 just contains an order ID. The formula is looking in the order adjustment worksheet for specific order ID in column B and then a row in column F that contains a cell with the text 'Added Manually'. If this doesnt appear in the order adjustment worksheet formula is returning blank otherwise it returns the value in column H.

In theory there sound not be two duplicate row in column F for the same order containing the text 'Added manually' but it might be nice to have a formula that could deal with this edge case but i would like to understand how to so the searching instead of direct match first

=IF(IFNA(INDEX(FILTER(order_adjustment!H:H, (order_adjustment!C:C=AM5)*(ISNUMBER(SEARCH("Added Manually", order_adjustment!G:G)))), 1)
,"TRUE")="TRUE","",CONCATENATE("Order has adjustment of £",XLOOKUP(1,(order_adjustment!C:C=AM5)*(order_adjustment!G:G="Added Manually"),order_adjustment!H:H),"<br>"))