=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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |