Pivot Table lookup
Ok here is my issue :)
I am working with many records and need a way to match a vendor name with a
part number, my table looks a such
A B
Part Number Vendor name
AH00000E
AH99999E
AI00000F
AI05500E
So what Im looking to do is take the First two letters of the part number
and assign a vendor using a pivot table we created on a sheet called
"VendorNames" to go in the "B" column
Any help would be geat :)
|