INDEX MATCH MATCH in Excel for two-dimensional lookup - Ablebits
https://www.ablebits.com/office-addins-blog/index-match-match-two-dimensional-lookup-excel/
WEBMar 14, 2023 · The INDEX function retrieves a value from the data array based on the row and column numbers, and two MATCH functions supply those numbers: INDEX(B2:E4, row_num, column_num) Here, we leverage the ability of MATCH (lookup_value, lookup_array, [match_type]) to return a relative position of lookup_value in lookup_array.
DA: 71 PA: 27 MOZ Rank: 63