HELP PLEASE! Determine scorre by look at number that is between two cell values

[mattbarb]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>Hi,


I would like to use a vlookup to determine the effort scope in column L by referring to the table in columns N,O,P.
For example if total days = 21 the effort score would 5 as it falls between the lo value in column O and the High in Column P.

Download: https://we.tl/t-6fMqQzxKfy


Hope this makes sense as I’ve been trying for ages.


Many thanks,

 

[Fluff]

How about
=INDEX($N$8:$N$17,MATCH(K8,$O$8:$O$17,1))

But what happens if col L is 15?

 

[mattbarb]

Thanks. Works perfectly!

 

[Fluff]

You're welcome & thanks for the feedback