Jul 29 2019 12:34 AM
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
Jul 29 2019 01:16 AM
please paste this formula in C2. And drag it till C530.
=IF(IFERROR(MATCH(A2,B:B,0),0)>1,"Found","Not Found" )
Jul 29 2019 01:40 AM
A shorter formula alternative in C2, copied down rows, is;
=IF(COUNTIF(B:B,A2),
"Found",
"Not Found")