Two-way lookups

Match a row and column to retrieve a value from a pricing or planning matrix.

Practical example

=INDEX(B2:M10, MATCH(A14, A2:A10, 0), MATCH(B13, B1:M1, 0))

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.