The booking matrix lists rooms down the side and sessions across the top. To return the Maple evening count, use one exact match for the room and one for the session.

Use the labels to find both positions

Put Morning and Evening in B1:C1 and Cedar and Maple in A2:A3. Enter 6 and 4 for Cedar, then 9 and 5 for Maple. Enter Maple in E2 and Evening in F2. Use this formula in G2.

=INDEX(B2:C3,MATCH(E2,A2:A3,0),MATCH(F2,B1:C1,0))

Both positions are 2, so the result is 5.

The Maple row and Evening column cross at 5.

Illustrated lookup matrix. Keep the headers outside the INDEX values range.

Change one label at a time

Change the session to Morning and expect 9. Then change the room to Cedar and expect 6. Keep unique row and column labels. If you extend the numeric range, extend the corresponding label range too so their positions still line up.

Changing Evening to Morning gives 9, and changing Maple to Cedar then gives 6.

Illustrated input tests. Change one coordinate at a time.

Microsoft’s INDEX function reference