Result: Grapes 'Intersection of row5 and col2 (cell B6) Result: 10249 'Intersection of row2 and col1 (cell A3) Result: 12 'Intersection of row1 and col4 (cell D2) Result: $14.00 'Intersection of row1 and col3 (cell C2) Result: 'Apples' 'Intersection of row1 and col2 (cell B2) Result: 10247 'Intersection of row1 and col1 (cell A2)
Let's explore how to use INDEX as a worksheet function in Microsoft Excel.īased on the Excel spreadsheet above, the following INDEX examples would return: =INDEX(A2:D6,1,1)
