I have part numbers in sheet 1, column A
I have new part number in sheet 2, column A and X references in columns F thought to Z
I need to return the part number that exists in sheet 2 that has a matching part number in the cross reference.
I just cannot get similar index match formulas to work!
Thanks
Bookmarks