|Here is what I am tying to do and appears to be a complicated task to say the least. I am trying to auto populate a score from a table by based of a raw score and age. Might be easier if I use an example:|
Marty is 33 years old, during a physical fitness test he does 75 pushups. Base on his age and raw score, he receives a final score of 100.
All of this information comes from a table with the age groups across the top and the raw score on the left hand side. Using this data you scroll down until you find the appropriate value and that's his real score based off his performance.
I realize it may be a bit confusing. However if anyone is familiar with the APFT table in the military then you have at least an idea of what I am looking at.
The end state for me is, being able to input a raw score and the system to take in account his age and find his real score.
Is this possible or am I asking to much of Excel haha?
message edited by donkthompson