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

Attached Files

Silikon.xlsx (19.6 KB, 4 views)

In addition, there are two same article numbers, which could be produced with two different F....numbers, so my wish were, that this information could be from on Cell A2 perhaps like as example for: 6549966000 --> result: F22697501;F30031601

Have a look at the formula in cells F2 and below of the sheet Tabelle2 of the attached workbook. It should appear correctly in your German version. According to the compatibility info it should be OK with Excel 2021.
Edit: Also look at cell G2 and below which uses C2 as you asked for,
2025-09-13_220207.jpg

Attached Files

MSOfficeForums53754Silikon.xlsx (25.2 KB, 1 views)