INDEX [users.business.uconn.edu]

A more sophisticated approach involves using Index - Match. A helpful video is at ... (This works on Excel 2019…with array formula features released in late 2018 and the update to Microsoft Excel’s calculation engine.) [Ctrl+ Shift + Enter was used in the past for array formulas.] ................
................