In a rectangular table has a unique headings of column and rows.
=OFFSET(<start_of_table>;N(MATCH(<row_header>;<first_column_of_table>;0));N(MATCH(<column_header>;<first_row_of_table>;0)))
Is there any way easier?
 | 1 | initial version |
In a rectangular table has a unique headings of column and rows.
=OFFSET(<start_of_table>;N(MATCH(<row_header>;<first_column_of_table>;0));N(MATCH(<column_header>;<first_row_of_table>;0)))
Is there any way easier?
| | 2 | No.2 Revision |
In a rectangular table has a unique headings of column and rows.
=OFFSET(<start_of_table>;N(MATCH(<row_header>;<first_column_of_table>;0));N(MATCH(<column_header>;<first_row_of_table>;0)))
Is there any way easier?
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.