INDEX and MATCH combination
INDEX and MATCH combination
Our mission is to find the area of this property.
This is the INDEX range.
To find the row, we use the MATCH function.
This is the search key.
And we find it in this range.
To find the column, we use another MATCH.
This is the search key.
And we find it in this range.
And here is the result.