Anyone know what to do here? I don't know if it should be an If Then formula or Vlookup or something else?
I have 2 worksheets in Excel
Partial List:
A B C
DESCRIPTION SIZE (mm) Qty MODEL/PART NO
2F 3120 CARBIDE ENDMILL REGULAR LENGTH 4 8519040
Master List:
A B C D E F G
EDP# Description List Price Code Product % Disc Final Price
2010010 1/8 x 3/8 2FL EXO-AL BN REG $17.88 BLZ Milling 30.00% $12.5160
8519040 3120 Carb 2FL EXO-AL BN REG $24.97 BLZ Milling 30.00% $17.4790
6710032 1/4 x 3/4 2FL EXO-AL BN REG $33.48 BLZ Milling 30.00% $23.4360
So I want to check through the master list for a matching MODEL/PART NO from the partial list.
If it is in the master list, then get the Final Price number from the master list and paste it into the partial list in a new field.
A B C D
DESCRIPTION SIZE (mm) Qty MODEL/PART NO Final Price
2F 3120 CARBIDE ENDMILL REGULAR LENGTH 4 8519040 $17.4790
Thx
I have 2 worksheets in Excel
Partial List:
A B C
DESCRIPTION SIZE (mm) Qty MODEL/PART NO
2F 3120 CARBIDE ENDMILL REGULAR LENGTH 4 8519040
Master List:
A B C D E F G
EDP# Description List Price Code Product % Disc Final Price
2010010 1/8 x 3/8 2FL EXO-AL BN REG $17.88 BLZ Milling 30.00% $12.5160
8519040 3120 Carb 2FL EXO-AL BN REG $24.97 BLZ Milling 30.00% $17.4790
6710032 1/4 x 3/4 2FL EXO-AL BN REG $33.48 BLZ Milling 30.00% $23.4360
So I want to check through the master list for a matching MODEL/PART NO from the partial list.
If it is in the master list, then get the Final Price number from the master list and paste it into the partial list in a new field.
A B C D
DESCRIPTION SIZE (mm) Qty MODEL/PART NO Final Price
2F 3120 CARBIDE ENDMILL REGULAR LENGTH 4 8519040 $17.4790
Thx
Last edited: