Trying to get cells to reference a 5x5 matrix

[ohsgoddess]

Hi I need help with an excel spreadsheet. I want the spreadsheet to
look at 2 cells and then refer to a 5x5 matrix in another sheet and
then fill in a cell based on what the matrix would make it. Based on
the number in the matrix, determines if the risk is critical 1-8, high
9-14, moderate 15-20 or low 21-25. If anyone could give me some help
that would be great.
Thanks

This is what the cells look like, the matrix comes from a different
sheet within the book.

(D58) (F58) (G58)
Exposure Rating B Thermal Stress Risk 2 Critical


Health Effect (Consequence) Rating
Exposure (Probability) Rating 5 4 3 2 1
A 1 2 3 9 16
B 4 5 10 11 17
C 6 7 12 18 21
D 8 13 19 22 23
E 14 15 20 24 25

 

[Pete_UK]

Assume that your matrix is in a sheet named matrix, and that the first
row of data (A 1 2 3 9 16) occupies A3:F3. Put this table in
that sheet, for example in L1:M4:

1 critical
9 high
15 moderate
21 low

then you could use this in G58:

=VLOOKUP(INDEX(matrix!B3:F7,MATCH(D58,matrix!A3:A7,0),MATCH(F58,matrix!
B2:F2,0)),matrix!L1:M4,2)

Hope this helps.

Pete