LOOKUP two data sets for match - return 1 or 0 - Please help!
Enter in say F1
=IF(ISERROR(VLOOKUP(E1,$B$1:$B$10,1,FALSE)),0,1)
and drag down to F10!
Regards,
Stefi
€˛Jay€¯ ezt Ć*rta:
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
|