Should be simple project for Excel Junkies.
I have two spreadsheets. one spreadsheet has 4 columns, the older one has 5. I need to lookup part numbers in the first spreadsheet, find the corresponding part number in the second spreadsheet, and return the weight which is only in the second spreadsheet.
Part prefix Part number Part number AN Description Currency Unit Price GPPS Weight in LBS
RM 80808801 RM 80808801 MIRROR USD PCE 92.83
RM 43920438 RM 43920438 GRILLE USD PCE 234.77
RM 14784060 RM 14784060 FLAT USD PCE 45.36
RM 95220919 RM 95220919 HOSE CLAMP USD PCE 2.29
Part prefix Part number Description GPPS Weight in LBS
VOE 11417933 GRAPPLE ARM 1598.6
VOE 11417932 GRAPPLE ARM 1589.7
SA 3328445 HEATER 5
VOE 17481105 CONVERSION KIT 255.8
VOE 17481108 CONVERSION KIT 0
VOE 17473398 CONVERSION KIT 0