Hi All

I'm a newbie to forums and also to formulas and macros in Excel, but i'm already hooked.
Using Vlookup, I have been a been able to put in a part code of a product and find it's piece number and location, but the company i work for is dealing with rolls of fabrics, each cut of a part code has a different piece number and can have different locations in our warehouse.
So my question is, can i search the the part code, which gives me a list of it's piece numbers, which then gives me the location of both the Part code and Piece number i desire?

Part Code:
SW2020-01

Piece No:
000001
000002
000003

Location:
01E02
25K03
06A04

Thanks in advanced