How to Extract A Number from String if Text within the String Equals XYZ

tyrsfury,

Attached is a modified version of your most recently posted workbook.
In cell O9 and copied over and down to cell W41 is this regular formula:

=IF(ISNUMBER(SEARCH(" "&TRIM(O$5&" "&O$6&" "&O$7)&" "," "&$Z9&" ")),--TRIM(LEFT(SUBSTITUTE(MID($Z9,SEARCH(O$7,$Z9)+LEN(O$7),99),";",REPT(" ",99)),99)),"")

Those cells are formatted as Number with 2 decimal places.
Column X is a Sum formula, and colymn Y is =N+X

Does that work for you?