** HELP ** MATCH/INDEX

sruk89 The INDEX array and the MATCH lookup_array need to be the same height. MATCH will return a row number that is passed to INDEX... if the row number exceeds the number of rows in the INDEX array, it will return an error.

Your formula is currently referencing K28:K32 as the INDEX array (5 rows), and D18:D32 / E18:E32 as the lookup_array in MATCH (15 rows). It would be more appropriate to have the list of applicable messages in the range H18:H32, for example, and use that range as the INDEX array.

However, looking at your screenshots, there doesn't appear to be any difference in the Interface Type between the 3 Switches, so you could simply reference the summary table in range I28:K32. For example:

=INDEX(K28:K32, MATCH(J22, I28:I32, 0))

...so long as the values in range I28:I32 also contain the appropriate (SMF) or (MMF) suffixes (in the screenshot they currently don't). I hope that makes sense.