CODEWITHSUNDEEP
excelcompare
munish
munish

Reputation: 4634

Search and compare two columns in excel

i have to columns in excel.

a      d
b      f
c      c
d      e
x
y
z
e

the secong list is a subset of first list.

i want to search the 1st list for the valus present in the 2nd and put it in 3rd column like

a      d   present
b      f   absent
c      c   present
d      e   present
x
y
z
e

Upvotes: 0

Views: 71

Answers (1)

Prabhat Srivastava
Prabhat Srivastava

Reputation: 197

Use this formula.

=IF(ISERROR(MATCH(B4,$A$1:$A$8,0))=TRUE,"Absent","Present")

Upvotes: 1

Related Questions