INDEX SECOND LOOKUP FUNCTION IN EXCEL

 If you want to get the Product of Amount? In that case, we can give INDEX both a row number and a column number, and feed in a larger array (range) of data. The INDEX formula below use the full range of data in B3:D11, with a row figure of 5 and column number of 2 Second

Note :-  How INDEX can be used to repossess a value in a 2 Second table?

Syntax :-  = INDEX(Array,row_num,{column_num) Enter

Example :- =INDEX(F6:G12,5,2) Enter