View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 1
Default 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