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!
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,123,426
Messages
5,601,595
Members
414,462
Latest member
StageRiis

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
Top