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