Enter part nrs consist....it display part number needed

Dont know if its a lookup or array?????. Want to enter the parts needed values in F2 H2 G2 and it will do a lookup and write Columns A value the Part nr in J2 K2 L2. Column B values will have duplicates so all instances must be written in J K L. Column A's values are unique and no duplicates are in Column A

I have over 2000 Part nrs inn Column A and I am looking for something to list the numbers. Any help appreciated and rep given

Workbook attached.....in the sample 316 was selected and all instances of 316 was written in JKL

Originally Posted by karedog

Maybe :

Please Login or Register  to view this content.

Karedog thank you so very much this solves it completely.......GREAT Coding!!!!!. Rep given