If this does not work, a sample workbook is needed.

First Sheet
A
B
C
D
E
1
Part #
Packaging
Part Description
List
Level 3
2
220
Box
2 Cond 22 Solid
$25
$17

Second Sheet
A
B
C
D
E
F
G
1
Item
Qty
Unit
Manufacturer
Model Number
Description
Unit Cost
2
220
2 Cond 22 Solid
$25.00

F2 =VLOOKUP(E2,'First Sheet'!$A$2:$E$2,3,0)
G2 =VLOOKUP(E2,'First Sheet'!$A$2:$E$2,4,0)