Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Field Lookup | Excel Discussion (Misc queries) | |||
Lookup within Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Lookup Grid | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Can I use a 'lookup' to a Pivot Table? | Excel Discussion (Misc queries) |