You can use the combination of INDEX and MATCH functions to lookup values both vertically and horizontally. Here's how you can do it:

1. Select the cell where you want to display the result.
2. Type the following formula:
   Code:

   =INDEX(B2:E5,MATCH(H2,A2:A5,0),MATCH(H3,B1:E1,0))

3. Press Enter.

Let's break down the formula:

- B2:E5 is the range of cells that contains the data table.
- H2 is the cell that contains the first input criteria (e.g. "Bruce").
- A2:A5 is the range of cells that contains the names in the leftmost column of the table.
- H3 is the cell that contains the second input criteria (e.g. "Good").
- B1:E1 is the range of cells that contains the rating categories in the top row of the table.

The MATCH function is used to find the position of the input criteria in the corresponding row or column. The INDEX function then returns the value at the intersection of the row and column.

So, in the example you provided, the formula would be:

This would return the value 6, which is the rating for "Bruce" and "Good" in the table.