Compare and find the difference between two column

Formula :

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),”not found”, “ok found it”)

Explanation :

A1 ~ keyword / what to find

$C$1:$C$5 ~ place to search / where to find

“not found” & “ok found it” ~ self described

everything else are not so important, just like us…

Tagged

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s