Hi

I use the following formula "=IFERROR(LOOKUP(2,1/($E$3:$E$92=K9),$I$3:$I$92),"") " to lookup specific text to find a value £.
K9 contains my specific text to search for

I need to modify the search to find the specific text which in some cases will now appear in a string of text.

Normally the entries in the list of items would appear like 'BT Group

Now I have entries that appears as '0334 24SEP15 , BANWY FUELS LTD , WELSHPOOL GB

The text to search for will be 'BANWY FUELS LTD

The numbers preceding BANWY FUELS LTD will continually change for each entry.

Many thanks in advance, your help will be greatly appreciated. Thank you.