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

What I want to do is locate the next appearance of a name and copy its
accompanying number.
Doing this manully is not feasible, given the large size of the s/s .

I have the following formula but have had it running for 5 hours now
and it is only down to row 22300:


Code:
--------------------

=IF(C3="","",IF(ISNUMBER(MATCH(1,(C4:$C$140=C3)*(L 4:$L$1400),0)),INDEX(L4:$L$140,MATCH(1,(C4:$C$140 =C3)*(L4:$L$1400),0)),""))

--------------------


Can anyone offer anything quicker or code??

I enclose a small attachment showing what I am trying to achieve but
for those who don't like opening attachments the wording in it is :

The desired objective is to place in column Q the next appearing number
in column L of the name in column C.
The VLOOKUP formula in column Q presents the desired number but
(problem!) presents a zero when next appearance = blank.
When this happens I want the formula/code to repeatedly lookup the next
appearance until it finds a number.
Examples of where next numbers appear are given here in column R.


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


+-------------------------------------------------------------------+
|Filename: example.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=60|
+-------------------------------------------------------------------+

--
colwyn
------------------------------------------------------------------------
colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47019