search in Matrix and give a Alphanumber in the right row back (index,match and/or aggregat)

[JanFr]

Hi All,

i have a problem with a formular. I tried to search the Matrix in sheet 1 DY4:EM57 for the article number in sheet 2 C2 and want to have the right F.....number from the column DY in sheet 1. My attempt was in cell: sheet 2 A2:



=WENNFEHLER(INDEX(Tabelle1!$DY$4:$DY$57;AGGREGAT(1 5;6;ZEILE(Tabelle1!$EA$4:$EM$57)/(Tabelle1!$EA$4:$EM$57=Tabelle2!C2);1)-1);0)

I am using the german version Excel 2021 from office 365, i think.

For your help i would be very thankfull.

best regards Jan