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

Thanks mate,

I tried your sample but when I try with my work sheet It does not work

The work sheet has 5856 rows,

I also paste those rows into your sample sheet and tried, but did not work , its only return 1.01 value to the first row.


Could you please help me

Originally Posted by davesexcel

Check out the amended code