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

		Microsoft Office Forums > Microsoft Excel > Excel
search in Matrix and give a Alphanumber in the right row back (index,match and/or aggregat)

FAQ

Thread Tools

Display Modes

09-13-2025, 02:05 PM

p45cal

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

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

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)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:38 PM.