Hi,



I have the following data in a spreadsheet: (note- I have also attached the spreadsheet to this post).

2015ID 2015Date 2015Type 2016ID 2016Date 2016Type
111 2/5/2014 E034 123 2/18/2014 E001
112 2/6/2014 E035 124 2/19/2014 E002
113 2/7/2014 E036 125 2/20/2014 E003
114 2/8/2014 E037 126 3/20/2014 E004
115 2/9/2014 E038 127 4/20/2014 E005
116 2/10/2014 E039 128 4/20/2015 E006
117 2/11/2014 E040 129 4/20/2016 E007
118 2/12/2014 E041 130 5/20/2016 E008
119 2/13/2014 E042 111 2/5/2014 E034
120 2/14/2014 E043 132 3/4/2014 E077


Is there a formula for where I can detect if 2015ID/Date/Type (all three listed across) are listed across, in order, in 2016ID/Date/Type? So example: the following values on the left (2015 data) in the first row are also listed in the columns on the left in row 10. Is there a formula that will allow for me to detect if data listed in the 2015 column is also listed in the 2016 column? My apologies if this was confusing, and thank you in advance!

Attached Files

Dummy Data.xlsx (13.4 KB, 12 views)