If cell A2 & B2 are Duplicates of A1 & B1 fill cell C2 with C1?

[MrMac80]

Hopefully the title explains

Trying to save time by getting excel to work with/for me. The sheet is needed to track a large and constantly increasing set of objects. There are connected cells to each object, that it would be great if when that object is recorded again (duplicated), rather than having to fill every cell, or go and copy and paste values, excel could do it for me.

is this possible? i have added an example sheet for reference.

(ps i have done research, but cant seem to find a solution that returns a value in another cell. I have find conditional formatting for duplicates, and also return static values, even counting, but not anther cell, hence coming here)

[6StringJazzer]

To return another cell:

Please Login or Register  to view this content.

I didn't take time to look at your file but from your description put this in C2:

Please Login or Register  to view this content.

The ? represents what you want if they are not duplicates.