Hello everyone,

I'm trying to extract data from a certain cell in a table, but instead of using exact values for one of the table's axes, I only have age and ID ranges.

excel.jpg

In this table, I need to get a value from a cell based on an age range (listed in column B) and an ID range (listed in row 4). So, if a user is 27 and has an identifier of 7, I need to be able to get a result of 2.3 back. Only problem is I can only get this to work if I specify the headings in exact values, i.e. I can only get a result if I say "26-30" and "6-7." The user needs to specify their exact age, not a range. But if they do, my spreadsheet won't be able to find the proper info because, obviously, "27" doesn't equal "26-30." Nor does "7" equal "6-7." Is there a way that I can get my spreadsheet to look at the data in column B and row 4 as ranges instead of exact values?

I've done a Google search on this problem and have found that there is a way to do this using left() and right() formulas, but I can't follow the logic on the pages I read this from. And when I just regurgitate (which isn't the best way to learn) the formulas, I get an error.

Can anyone help?