V Look Up? or Conditional Format?

[VPLUMWOOD]

Hi,

I have created a spreadsheet that calculates the average score of something to give a number, the table below is in a sperate tab, so if the number is between 0 and 1.75 I need the look up to bring back prior attainment group 1, similarly if the average score is 1.75 to 1.99 I need it to being back 2........ there are 19 different averages (I only copied the top 4) and Im not sure how exactly is the best way to work out the formula?

Prior Attainment Group	KS1 Average points score	Average KS2 Reading Score for PAG	Average KS2 Writing Score for PAG	Average KS2 Maths Score for PAG
1​	0 to <1.75	63.01​	62.82​	63.15​
2​	>=1.75 to<2	67.27​	66.68​	67.89​
3​	>=2 to <2.25	70.64​	70.1​	71.45​
4​	>=2.25 to <2.5

 

[VPLUMWOOD]

This seems to have worked - thank you so much!

	Prior Attainment Group	KS1 Average points score
0 to <1.75	1	0
>=1.75 to<2	2	1.75
>=2 to <2.25	3	2
>=2.25 to <2.5	4	2.25
>=2.5 to <2.75	5	2.5
>=2.75 to >3	6	2.75
>=3 to <3.5	7	3
>=3.5 to <=4	8	3.5
>4 to <5	9	4
5	10	5
>5 to <6	11	5.01
6	12	6
>6 to <7	13	6.01
7	14	7
>7 to <8	15	7.01
8	16	8
>8 to <9.5	17	8.01
>=9.5 to <10	18	9.5
10	19	10

 

[Fluff]

Glad to help & thanks for the feedback.