formula to find text and use the value in its adjacent cell???

I need help figuring out a formula to find a specific text in a worksheet that has various text and numbers. For example, I will need to find the word USFIT and the amount in the cell to its right, and place that in a cell in a different column. Is there such a formula? Please help. Thanks.

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)

Hi

assuming that your example data is in the range A1:B3, then

D2: =IF(AND(SEARCH("USFIT",A2),LEN(B2)>0),C1-B2,"")

If this doesn't really reflect your situation, then create an example spreadsheet, and give the expected result(s) for any relevant examples.

rylo

Thanks for your help, that worked...You are awesome.