I have an almost random sheet of numbers and words in different cells
and rows.

What I need is a formula that can do a couple of things:
On a seperate sheet I want to have a formula that looks for "Run
number" in colum C show me the what is beside it in Colum D

I also need to offset in some cases so if the "Run number" is found in
C678 I want to offset to D785



Please help

Thanks