stephnoven
New Member
 Joined
 May 2, 2021
 Messages
 3
 Office Version

 365
 2010
 Platform

 Windows
So I moved the data that I want to use into 1 sheet and I want to compare data on Column 1 with Column B.
I want to find out if the data on Column 1 also exist in Column 2.
I am using "1" for exist, and "0" for not existing.
The problem is, first I tried using my office notebook, but all the results show "1" (Excel 2013)
Then, I tried the formula with my personal notebook, but using sample data, since I can't transfer the data to outside, and success (Excel 365)
I'm not sure whether the Excel version affects the result.
Formula that I used:
=IF(ISNA(VLOOKUP(A2,$B$2:$B$6,2,FALSE)),1,0)
Sample:
Thank you in advance!
I want to find out if the data on Column 1 also exist in Column 2.
I am using "1" for exist, and "0" for not existing.
The problem is, first I tried using my office notebook, but all the results show "1" (Excel 2013)
Then, I tried the formula with my personal notebook, but using sample data, since I can't transfer the data to outside, and success (Excel 365)
I'm not sure whether the Excel version affects the result.
Formula that I used:
=IF(ISNA(VLOOKUP(A2,$B$2:$B$6,2,FALSE)),1,0)
Sample:
Data Source  Promotion Takers Data 
1212ASD  1234ZXV 
1234ZXV  1212ASD 
1168ASD  0865JKKL 
1240THY  1240THY 
1764NDH  1584QTYU 
0865JKKL  
1234XRBY  
1097RTIB  
1584QTYU 
Thank you in advance!