![]() Returns a cell address (reference) as text, according to the specified row and column numbers. =INDEX((multi) 0 0 2) returns a reference to the second range of the multiple range. =INDEX(A1:B6 1 1) indicates the value in the upper-left of the A1:B6 range. If you now want to call the second block of this multiple range enter the number 2 as the range parameter. ![]() The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. =INDEX((multi) 4 1) indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under Sheet - Named Ranges and Expressions - Define as multi. =INDEX(A1:B6 0 1) returns a reference to the first column of A1:B6. =INDEX(A1:B6 1) returns a reference to the first row of A1:B6. =INDEX(SumX 4 1) returns the value from the range SumX in row 4 and column 1 as defined in Sheet - Named Ranges and Expressions - Define. =INDEX(Prices 4 1) returns the value from row 4 and column 1 of the database range defined in Data - Define as Prices.
0 Comments
Leave a Reply. |