Vlookup (Headache)

hello

Please see attached

Tab Master
i want to enter pallet data onto this sheet,

Tab Pallet 1
I want the pallet 1 tab to return everything that’s on pallet 1 on the master tab, multiple part numbers can appear on the pallet sheet, I want the pallet tabs to return whatever is specific to the master tab

I think I’m close, but for some reason is repeating data

I need the pallets sheets return whatever I put on the master,


Paul