Help needed for "find"

Neitrino

New member
Joined
Aug 13, 2011
Messages
2
Reaction score
0
Points
0
I have a huge column A with some data, on another sheet or on the same sheet I have another column B with some other data...

Is it possible and how should I tell excel to search individualy all values from column "A" in column "B" and if column "B" contains values that exist in column "A" then let the next right neighbouring cell (to column "A" cell) turn into green or let there appear "ok" notification...


May u pls help i need this urgently
thank u
 
Insert a column next to A. This will make column B your column C.
Then enter this formula (I am assuming you start in cell b2).
=if(iserror(vlookup(a2,C:C,1,0)),"","OK")
This will display OK if it exists, leave it blank if it does not.
 
Back
Top