Quick question:
I know about the index match function, but don't have a clue how to write an
expression for it.
I have 2 work sheets: NewCrib and OldCrib. On each I have a PartNumber
column where some of them match in each worksheet. I need to replace the
Designation in NewCrib with that from OldCrib each time the PartNumber
matches.

Any help would be much appreciated.
Cheers