LOOKUP two data sets for match - return 1 or 0 - Please help!

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

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
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Lookup returning wrong results 0
need a search/find/lookup function 4
Match 2 Columns, Return 3rd, Differing Match Types 3
Help with Vlookup Match and IF statement 2
vlookup and match first value greater than 4
problem with lookup function 2
Vlookup and If statement help 1

Back
Top