Not sure what the data formula is to do this, I have a spreadsheet of part # for Jeep vehicles. I need to match up part # to the vehicle model and also parts category.
1. Need finished list with all 24,713 part # matched to category names and Jeep vehicle models
I have already matched up 5,743 part # (A) to Jeep models (B) to category name (C)
7,557 part # / category name need to be matched up
24,713 part # /vehicle model # / category name total – 5,743 are done - 18,970 are left to do
A – all matching part # (duplicate part # because 1 part # can match multiple Jeep vehicle model in column B)
B – Jeep vehicle model # (by year) that match part # in column A
C – category name that part # in column A matches
E / F – part # (E) and their matching category name (F), unsorted
Need to match remaining category names in column F - to part # in column A that match the part # in column E.
If part # in column E matches part # in column A, put category name in Column F into...