Yes or no return on a comparison of two colum

[Solved/Closed]
Report
-
 Fooberry -
Hello,

Column A contains 80 cells with numbers such as this, not in sequential order: 3-1705578711
Column B contains 50 cells with numbers similar to column A.
Column C should contain the formula indicting if the numbers in column B can be found in column A.
True or false value/ Yes or No are acceptable.

I have tried Vlookup and lookup but no success.

Please help.

=VLOOKUP(B2,$A$1:$A$80,B,FALSE)


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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.
Resolved. Thanks for your reply.

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.