I have 2 columns that I need to compare and verify which valuesmatch between the two. There are a fewcells that only have parcel text. I needa formula the will compare the both columns and search for the parcel text andreturn the value. Below is an example ofwhat I am trying to do. Your help wouldbe most appreciated. J DCNIFA A DCNIFW W DCNIFX X DCNIFY Y DCNIFZ Z =Compare DCNIFA with A with a return value of A =Compare DCNIFW with W with a return value of W =Compare DCNIFX with X with a return value of X =Compare DCNIFX with X with a return value of X =Compare DCNIFZ with A with a return value of Z

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Partial match

Thread starter cates79
Start date Aug 28, 2018
Tags

=compare dcnifw dcnifx return text

cates79

New Member

Aug 28, 2018

I have 2 columns that I need to compare and verify which valuesmatch between the two. There are a fewcells that only have parcel text. I needa formula the will compare the both columns and search for the parcel text andreturn the value. Below is an example ofwhat I am trying to do. Your help wouldbe most appreciated. J

DCNIFA	A
DCNIFW	W
DCNIFX	X
DCNIFY	Y
DCNIFZ	Z

=Compare DCNIFA with A with a return value of A
=Compare DCNIFW with W with a return value of W
=Compare DCNIFX with X with a return value of X
=Compare DCNIFX with X with a return value of X
=Compare DCNIFZ with A with a return value of Z