Searching data based on user input

[fhm_2025]

Hi,

I would really appreciate if you could provide some help on this.

I have extracted data (sample below) from our oracle server through power query and added the data in a data model.

Part#	Sourcing Rule	Manufacturer Number
548963	Halifax	NorthSam
328761	California	SouthSam

Now, if my user paste some part number in a column in excel like below and hit refresh button then excel should take those part numbers and populate ”Sourcing Rule” and “Manufacturer Number” by matching the part number that user provided

User input -

Part#

548963

895632

745963

635891

223896

 

[GraH - Guido]

User input needs to be a named range, which you can do dynamically.

Load this data (from named range) in PQ.
Merge this one with the table from Oracle, doing an inner join on Part#.

Load in Excel.

I would also do a trim on the column, as extra spaces are easily typed or copy pasted in.