Table lookup with criteria between range of numbers
Results 1 to 3 of 3

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

  1. #1
    New Member
    Join Date
    Sep 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    Board Regular
    Join Date
    Feb 2015
    Posts
    192
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #3
    New Member
    Join Date
    Sep 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Table lookup with criteria between range of numbers

    Sorry, you're right.

    The data comes in like this:

    Screen_Shot_2017_09_29_at_2_28_53_PM

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

    Screen_Shot_2017_09_29_at_2_35_41_PM

    Does that help?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •