ExcelBanter - LOOKUP two data sets for match - return 1 or 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LOOKUP two data sets for match - return 1 or 0 - Please help! (https://www.excelbanter.com/excel-worksheet-functions/111593-lookup-two-data-sets-match-return-1-0-please-help.html)

Jay

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

Stefi

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

All times are GMT +1. The time now is 07:25 AM.