Solved Using data from another sheet to auto populate on original

August 25, 2016 at 03:31:32
Specs: Windows
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

See More: Using data from another sheet to auto populate on original

Reply ↓  Report •

August 25, 2016 at 05:31:28
✔ Best Answer
I don't have access to Excel at the moment, but it sounds like a combination of the INDEX and MATCH functions should work for you.

If you use your favorite search engine and look for index match excel You get lots of hits.

It seems like Example 3 here might be what you are looking for:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Reply ↓  Report •

August 25, 2016 at 08:15:11
Thanks! I'm away from the office until tomorrow however I will check it out and definetl yet you know how it goes. Appreciate the advice!

Reply ↓  Report •

Related Solutions

Ask Question