Find Value based on user criteria
I had this question answered earlier but I change the format and cant figure out how to manipulate it to work with this new format.
On sheet 1 the user enters the Gender, Age, and Time, then a forumula will compute the score. On sheet 2, row 2 is age block and the cells in green is the time. So an example of Male, 42, 11.39 run time, would be 56.3. Attached is example workbook
Book2.xlsx
On sheet 1 the user enters the Gender, Age, and Time, then a forumula will compute the score. On sheet 2, row 2 is age block and the cells in green is the time. So an example of Male, 42, 11.39 run time, would be 56.3. Attached is example workbook
Book2.xlsx
ASKER
Martin, sorry yes rows 4 to 35, looking for a formula.
If the run time were any value from 11.24 to 11.39 would the score still be 56.3?
ASKER
For a Male at 39 it would 52.4 if he ran between 11.24 and 11.39, if it was a female it would be it would be 58.6
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You Martin, it works perfectly.
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015
Do you want a macro or a formula?