InventoryQueryGuy wrote:
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

Maybe you could upload an example file to www.savefile.com


--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy