I have 2 spreadsheets, one with 2006 data and one with 2007. In the 2007 data, I would like to insert a field that compares lines and tells me whether or not each line is "new" (does not appear in the 2006 sheet). Also, I am not simply comparing one cell, but several different ones, for example:
SCENARIO #1:
2006 data
Cell A1: X
Cell B1: X
Cell C1: X
2007 data (this scenario would return the value "OLD")
Cell A1: X
Cell B1: X
Cell C1: X
---------------------
SCENARIO #2:
2006 data
Cell A1: X
Cell B1: X
Cell C1: X
2007 data (this scenario would return the value "NEW")
Cell A1: X
Cell B1: X
Cell C1: Y
I'm assuming it's some sort of crazy VLOOKUP function, but please let me know what you think. Also, the lists are in no particular order, not sorted a specific way, etc., so each item is out of place.
SCENARIO #1:
2006 data
Cell A1: X
Cell B1: X
Cell C1: X
2007 data (this scenario would return the value "OLD")
Cell A1: X
Cell B1: X
Cell C1: X
---------------------
SCENARIO #2:
2006 data
Cell A1: X
Cell B1: X
Cell C1: X
2007 data (this scenario would return the value "NEW")
Cell A1: X
Cell B1: X
Cell C1: Y
I'm assuming it's some sort of crazy VLOOKUP function, but please let me know what you think. Also, the lists are in no particular order, not sorted a specific way, etc., so each item is out of place.