How to search a column with keywords and write decimal value in to a row

Hi ,

I have a excel work sheet. It has 5856 file names in the B column.
I want to search particular file name by keyword search.
If the keyword match with a file name or part of the file name then I want to write a new decimal value in the same row but in the C column.


For example I want to search Project management keyword in the B column (B1:B5856). If I found three results such as in B5, B10, B5050 then I want to write 1.01 values in to C5, C10 and C5050.


Could you please help me?