LOOKUP two data sets for match - return 1 or 0 - Please help!
I have a data set (numbers) say B1 to B10. I have another data set
(numbers) E1 to E10. I want to compare a value in set E with Set B and
return 1 if there is a match. If not I want to return 0. I want to do
this for the entire set E.
Please help!
Thanks in advance,
Jay
|