Yes or no return on a comparison of two colum
Solved/Closed
Related:
- Yes or no return on a comparison of two colum
- Flipkart return comments - Guide
- Display two columns in data validation list but return only one - Guide
- Zuma return - Download - Puzzle
- If a cell has text then return value ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 12, 2011 at 08:01 AM
Oct 12, 2011 at 08:01 AM
supposed sample data is like this from A1 down (2 columns data)
1 1
2 3
3 5
4 7
5 9
6
7
8
in C1 copy this formula
=IF(ISNA(VLOOKUP(A1,$B$1:$B$600,1,FALSE)),"no","Yes")
copy C1 down and see.
use this in your data.
1 1
2 3
3 5
4 7
5 9
6
7
8
in C1 copy this formula
=IF(ISNA(VLOOKUP(A1,$B$1:$B$600,1,FALSE)),"no","Yes")
copy C1 down and see.
use this in your data.
Oct 12, 2011 at 08:40 AM
I used the following which was taken from another post here:
=IF(B2=$A$2:$A$25,1,2)
instead of using the full range of cells I used a smaller sample that originally indicated.
I also decided to drop the output of Yes or No and used 1 or 2 as a resulting output just to make those that adhere to the binary 0 and 1 go crazy. Ha! take that!
Cheers.