You assume that all search values appear in Sheet2.

Yep. That's what this means:

Making a few assumptions...

I'm also assuming that the range(s) noted by the OP are the REAL ranges.

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Biff,

You assume that all search values appear in Sheet2.

I don't.

Regards,
Bernd