Getting single value for range of values

[02Bimm3r]

Good morning all,

I am not an experienced excel user. I can usually figure out fairly simple formulas to figure out averages, ranks, etc. I have run into one that I can not for the life of me figure out. It may be fairly simple also, but I just cant get it. I run a physical training program, and I use a spreadsheet to figure percentage results. In the past, I have just gone off a sheet and manually entered percentages based off of what scores were given. Basically, if you get x amount of pushups, you get y%. I am trying to get excel to do this for me to save time. As much time as I have spent trying to figure this formula out, I probably could have manually entered them several times over . Can anyone give me an idea of how to enter it? I've attached a table of ranges that I am basing this off of. So, when I enter a score in G2, I want G3 to populate a percentage based on the below chart. Please let me know if anyone can help. Thank you so much!!

Min	Max	Percentage
0	24	0
25	29	15
30	34	30
35	39	45
40	44	60
45	49	70
50	54	80
55	59	90
>60		100

<tbody>
</tbody><colgroup><col><col><col></colgroup>

Ryan

 

[steve the fish]

Hi. Change your >60 to just say 60 then use something like:

=LOOKUP(G1,A2:A10,C2:C10)

Where G1 contains your value to lookup and your table is in A1:C10.

 

[wideboydixon]

A simple VLOOKUP should be enough here:

Book1
	A	B	C	D	E	F	G
1	Min	Max	Percentage
2	0	24	0				77
3	25	29	15				100
4	30	34	30
5	35	39	45
6	40	44	60
7	45	49	70
8	50	54	80
9	55	59	90
10	60	Lots	100
Sheet1

Cell Formulas
Range	Formula
G3	=VLOOKUP(G2,A2:C10,3,TRUE)

WBD

 

[02Bimm3r]

You guys are the best. I tried this yesterday, but for some reason it was not working. Its working and doing exactly what I need now. Thank you so much!