Very simple Division question

Copper Contributor

Dear community,

 

I have 2 columns with data, A longer, B shorter. I want to compare if in column A there is any vaule from column B ? A is from A2 to A530 and B2 to B270. I don`t want to compare it manually.

 

Regards

3 Replies

@Progression 

please paste this formula in C2. And drag it till C530.  

=IF(IFERROR(MATCH(A2,B:B,0),0)>1,"Found","Not Found" )

 

@Progression 

A shorter formula alternative in C2, copied down rows, is; 

=IF(COUNTIF(B:B,A2),

"Found",

"Not Found")

Thank you!