Converting Score Sheet to LOOKUP formula?

[RDSProgrammer]

I have a paper-based scoring sheet that we use to determine a rating category. I cannot figure out how to convert this scoring sheet into a lookup region and use some type of LOOKUP formula to determine the rating. I have looked at the various Grading examples on the Internet that show you how to look up a grade, based on a score, but they only look up a grade, based on a single input (the score).

Here I have two values going in--the person's age and their score, and I need to look up the rating, which is the column heading.

Can anyone point me in the right direction?

I've attached a sample spreadsheet which shows the original scoring sheet.

[zbor]

Check this out...

Determine%20Rating(1).xls

[martindwilson]

perhaps this

[zbor]

Nice... Much easier

[martindwilson]

only does one at a time tho!

[RDSProgrammer]

It looks as though you normalized the original scoring table.

Is there another way to determine the correct rating column, while preserving the essence of the original table's scoring rules. I ask this, because we have some non-technical people who will need to maintain the scoring tables and I don't think they will be able to understand a matrix of ratings.

I've updated the spreadsheet to show the beginning of how I tried to approach this--but I still don't know how to get the correct column.

I was trying to figure out how to use a combination of VLOOKUP for the correct age row, and a HLOOKUP for the correct column in that row.

[RDSProgrammer]

perhaps this

Thanks, martin. That was exactly what I was looking for. In hindsight, it seems pretty simple ;-)

[martindwilson]

just done this in case you wanted to do more than one