Vlookup (Headache)

[pmw19800]

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

[63falcondude]

Since I assume that you will be continuously adding to the data in the 'Master' worksheet, I would make that data into a table.

Then, in the 'Pallet 1' worksheet, you can use something like this:

B3 =IFERROR(INDEX(Table1[[Part Number ]],SMALL(IF(Table1[Pallet]=1,ROW(Table1[Pallet])-(ROW(Master!$A$2)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter
C3 =IFERROR(INDEX(Table1[Description],SMALL(IF(Table1[Pallet]=1,ROW(Table1[Pallet])-(ROW(Master!$A$2)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter
D3 =IFERROR(INDEX(Table1[Reference],SMALL(IF(Table1[Pallet]=1,ROW(Table1[Pallet])-(ROW(Master!$A$2)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter

The formulas for the other worksheets will be the same except you will have to change 1 to 2 or 3, depending on which sheet you are on.

See attachment for clarification.