Debra Dalgleish has some instructions:
http://contextures.com/xlFunctions03.html#IndexMatch2



colwyn wrote:

Thanks Alan. I can see how that works but with over 320000 rows of data
it would take forever to implement an array formula and I'm trying to
avoid that. I'll wait to see if someone can come up with something that
avoids an array.
Maybe there is code which would work.
Big thanks.
Colwyn.

--
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=40942

--

Dave Peterson