Hi all,

I have a list of products (sheet 1) that I need to find the locations for goods picking, the master inventory list (sheet 2) has the same product code but with different location, what function should I use so that my (sheet 1) can view all possible location. Example as follows:

(sheet 1)
Product no Location
123.11
124.12
123.23

(sheet 2)
Product no Location
123.11 A01
123.11 A02
123.23 B01
123.23 C01
123.23 D01
124.12 F01


Please help.

Thank you very much.