Thread: search in Matrix and give a Alphanumber in the right row back (index,match and/or aggregat)
View Single Post
 
Old 09-10-2025, 02:33 AM
JanFr JanFr is offline Windows 10 Office 2021
Novice
  
Join Date: Sep 2025
Location: Hanover
Posts: 2
JanFr is on a distinguished road
Cool search in Matrix and give a Alphanumber in the right row back (index,match and/or aggregat)
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
File Type: xlsx Silikon.xlsx (19.6 KB, 4 views)
Reply With Quote