how do I retrieve next occurring value?

I'm using Excel 2007 and s/s is 325501 rows deep. It consists of a series of approx 30000 ranges between 4 and 30 rows deep.

What I need to do is locate the next appearance of a name and copy its accompanying value to the present occurrence. Doing this manully is not feasible, given the large size of the s/s and I would like to acquire code.

The names are in column B and the values to be retrieved are in the adjoing cell in column C.

The code should only act when there is a number in column S and retrieved values should be placed in column V.

So if XXX appears in B2 and B345 and C345 contains 932, I need 932 to appear in V2.

If anyone can help me to this end I would be most grateful.
Big thanks.
Colwyn.