I am using =index,match,match to extract data from an array which I
don't control. It worked fine whilst the entries in the left-most
column were sorted (descending) but with new lines being added by other
users, the formula is now returning garbage. I've tried a number of
methods but nothing that doesn't involve numerous steps seems to work
consistently.

Any idea sout there?


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=470386