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:
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:
But none of these have worked
All text is formatted as "General"
Thanks for you help in advance!
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!