To get you started to learn how record a macro while selecting col c and
doing an editfind

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
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