Hi Everyone,

I have a Sheet ( Named "Data" ) that has One Combination ( in the
Format 01-02-03-04-05-06 ) in Each Cell from A1:Z65000.
In Another Sheet ( Named "Draws" ) I have a Column ( Column "B" for
example ) with Several Hundred Draw Numbers in it.
What I would like to do is to Check if the Combination in Cell "B1" (
in the Sheet Named "Draws" ) is Anywhere in the "Data" Sheet. If it
is, it could put "Found", and if NOT put "Not Found" for example. Then
do the same for "B2","B3","B4" etc.
Is there a Formula that would achieve this or would it have to be done
using VB.

Thanks Very Much in Advance.
Paul