Hi,

I would like to get help in designing a table for representing a range in a column. Lets say we have a excel sheet of a matrix like below.

GameName | agegroup 20-24 | agegroup 25-29

------------------------------------------

Cricket | ------5--------|-----7------

Football | ------3--------|-----9------

Lets say the numbers represent the number of medals(just for example sake).

How best to design the table so that when the inputs are 'Cricket' and age '27', I should get the result back as '7'. The problem here is to represent a range as a column.

Soemthing like each column represents a lower/upper range. But I am not able to comprehend how to design a table for this.

Any help is appreciated.

Note : -- are just for formatting. Only numbers should be considered.

Thanks.