Search the xcel data for the number in a cell. If yes then copy a cell from that row to another cell

Hi the below data is in xcel. I need to put the downstream number eg.6.25(cell L2) into Cell L1. But this has to be found from the database. So if Cell B1 matches anywhere in column B copy the L value from that row and copy to the L column in the original row i.e L1.

I'm really struggling with this one and have a deadline today!! Thanks in advance!

PIPE 17888 Upstream Pit ID 20447 Concrete Circular Pipe 1/04/2015 380 6.36 img008.jpg

PIPE 17888 Downstream Pit ID 22105 Concrete Circular Pipe 1/04/2015 380 Downstream 6.25 img010.jpg

PIPE 17854 Downstream Pit ID 22105 Concrete Circular Pipe 1/04/2015 380 Downstream 6.36 img010.jpg US PIPE NOT FOUND PIPE 17811 Upstream Pit ID 22105 Concrete Circular Pipe 1/04/2015 380 6.25 img010.jpg

PIPE 18105 Downstream Pit ID 23037 Concrete Circular Pipe 1/04/2015 600 Downstream 5.94 img014.jpg