VLOOKUP and Pivot Tables

dschwartz0815

New Member
Joined
Jul 17, 2018
Messages
1
Hello all,

I've done quite a bit of searching and haven't had any luck with suggested answers short of writing some kind of custom VBA code

I'm working within 1 single Excel Spreadsheet:
  • Sheet1: contains raw data exported from a manufacturing quoting software
  • Sheet2: PivotTable that breaks down the raw data into just a Part Number, Price, Lead Time, and Supplier
  • Sheet3: A query from our database that pulls our internal part numbers that are linked to a global manufacturer part number

What I'm trying to accomplish:
I've placed a column next to my pivot table where I'm trying to make use of a VLOOKUP function to pull the manufacturer part number from the pivot table and match it to the database query and return the possible internal part number. The database query return doesn't pull just the MPN exactly, so it has be a partial match.

IE. The Manufacturer PN is "03386-T369" and in the database query we have "03386-T369~SUMIDA AMERICA COMP" which should pull back the linked internal part number in column 1

I've written VLOOKUP's as so:
  • =VLOOKUP(A2,PartNumbers,1,TRUE)
  • =VLOOKUP(A2,PartNumbers,1,0)
  • =VLOOKUP("*"&A2&"*",PartNumbers,1,0)

But none of these have worked

All text is formatted as "General"

Thanks for you help in advance!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top