Alan, Thanks.

You certainly have put a lot of effort into this collection.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Alan Beban" wrote in message
...
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, you might
want to consider the ArrayMatch function. It will return an array of the
row index and column index numbers within the array (or range) where
matches are found, or, for a range, with use of the optional 4th
argument it will return an array of the worksheet addresses of the
matches.

Alan Beban

Rob van Gelder wrote:
Tom,

That's an amazing shortcut for quickly searching a 1D array. I like it.

Do you know if it's possible to search a 2D array that way?