I am not great at formulas, but I did try the Vlookup formula and it is not quite what I need. I would like excel to find any instances where the word USFIT is found, then to take the amount to its right to use in another formula...to be subtracted with another cell amount. Here is an example below. Please advise. Thanks.

A B C D
1 Earnings 404.00 16.16 (I want this formula to take the amount in B2 and subtract from C1, only if there is a # in B2)
2 USFIT 5.86 (There will be some instances where there is no USFIT, and there are also a lot more text and- numbers included on this worksheet)