# Thread: Table lookup with criteria between range of numbers Thanks: 0 Likes: 0

1. ## Table lookup with criteria between range of numbers

Hi everyone. I am making a fitness testing spreadsheet that puts you into different levels (1-5) depending on your performance. The tables below show Resting Heart Rate with separate tables for Male and Female. The gender, age, and Resting Heart Rate results are in another sheet (shown below).

I want to create a formula that outputs the level you are based on those criteria. I've been playing around with INDEX, MATCH, and VLOOKUP, but I'm not very advanced in Excel and don't know how to deal with the ranges for age and resting heart rate.

Thank you much!

2. ## Re: Table lookup with criteria between range of numbers

a table of data and table of what you want your output to look like might help...

3. ## Re: Table lookup with criteria between range of numbers

Sorry, you're right.

The data comes in like this:

And all I want is a simple table that outputs the level as a number. Something like this:

Does that help?