But, error trapping application.match wasn't working... until I found
the IsError(Application.Match method. That seems to work a lot better.



On Sep 3, 2:47 pm, Dave Peterson wrote:
And if you want the row number, application.match makes a lot more sense.

c mateland wrote:

A simple error trap seems to be working now with a match that cannot
resolve. Since the match is more reliable than the countif, I'll test
using the match with error trapping instead.

On Sep 3, 1:58 pm, c mateland wrote:
(I use the countif before the match because I can't figure out a way
to do an error handler for a match for a non-existant lookup - any
suggestions?)

--

Dave Peterson