Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

What is the best way to get the value of a rectangular table?

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?

What is the best way to get the value of from a rectangular table?

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?