Thanks Dodo,

Yes I could sort column B, if I did how would I construct the lookup bearing
in mind I need to match specific values in column A to any in B ?

"Dodo" wrote:

"?B?QWRhbQ==?=" wrote in
:

I need to see whether any of the values in column A are missing from
column B.

EG:

A B C

ab4 ah6 no match
ab5 zqv no match
abs abs match
abv abv match


Pity it isn't your B-column that is sorted. You could then have used the
vlookup function.
Perhaps you can copy the B-column values to a different column, sort it
there and then do the lookup?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)