I have 2 worksheets, one is the original and one has been modified.
the modifications mean that some of the (unique) cell contents have moved to another cell.
I need to build a 3rd sheet that will tell me where those cell contents have moved to in relative terms e.g. 2 rows across and 3 cells down.
is this possible? I'm thinking INDEX, MATCH and FIND but can't work it out. I could do it with MATCH if it was just one column.