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

JanFr · #1 09-10-2025, 02:33 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple match values for INDEX(MATCH) formula	jn82740	Excel	1	06-24-2023 11:48 PM
Extract a matrix of another matrix defined by selected rows marked with an x	Tommy7571	Excel	19	03-20-2019 08:39 AM
2nd matrix gives a resut that doesn´t match numbers in the 1st matrix	Diver	Excel	25	02-22-2017 04:39 PM
Two criteria search in a matrix	Diver	Excel	9	02-14-2017 04:17 AM
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM