| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data | Excel Discussion (Misc queries) | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
| Lookup thinks data isn't sorted | Excel Worksheet Functions | |||
Linear Mode
