Trying to write a formula

Question

I have a formula where it looks up a VLookup. However, it is not recognising some of the values.
For example the values 30 pp to 99 pp is not recognised and it applies the formula as if it is a 200 pp top 299 pp.
Here is the formula I am using and the VLookup.
&nbsp;
=VLOOKUP(F3,Scores!$B$2:$D$8,3,TRUE)
&nbsp;

Range1
50pp
Value

30 pp
99 pp
3

100 pp
199 pp
5

200 pp
299 pp
7

300 pp
399 pp
10

400 pp
499 pp
15

500 pp
1000 pp
20

&nbsp;
&nbsp;
&nbsp;

sergeibaklan · Answer

Hi Brian,
&nbsp;
With range lookup = TRUE the first column shall be sorted in ascending order, in your case like
100 pp
200 pp
30 pp
300 pp
etc.
&nbsp;

Forum Discussion

Trying to write a formula

Share

Resources

Range1	50pp	Value
30 pp	99 pp	3
100 pp	199 pp	5
200 pp	299 pp	7
300 pp	399 pp	10
400 pp	499 pp	15
500 pp	1000 pp	20