Originally Posted by Dominique Gascon

I searched the whole column, but you may want to use a named range or dynamic range to restrict the search, but I don't think that it does make much difference performance wise.

see attached example.