how can matching code that have duplicate code

[Akatecho]

Dear All,

I have a Excel table in Excel file and i need to get the code from tab name "Withpack" to Sheet1.

when i fill code at C10 then code will show at C11 C12 C13... by get data from Withpack at column A

that have code same as C10 in sheet1 in J column at Withpack sheeet.

Thank you in advance for help me

[JohnTopley]

Try

in C11

=IFERROR(INDEX(Withpack!$A:$A,SMALL(IF(Sheet1!$C$10=Withpack!$J$3:$J$12,ROW(Withpack!$A$3:$A$12),""),COLUMNS($A:A))),"")

Enter with Ctrl+Shift+Enter

Drag across columns