How to look up and return a value from a cell?

[Steve Swift]

Hi Guys,

Can anyone help with the formula I would need to use to have cell C1 show the words "Level 5" in the attached example?

Column B shows a number of 'points' and Cell B1 is a changing value, if B1 was showing a figure above 10,000 but below 25,000 then cell C1 should show 'Level 2'

<!-- copy and paste. Modify height and width if desired. --> <a href="https://content.screencast.com/users/wizzint/folders/Snagit/media/57467249-f780-465f-a1df-bf3b2027ebba/11.04.2018-11.54.png"><img class="embeddedObject" src="https://content.screencast.com/users/wizzint/folders/Snagit/media/57467249-f780-465f-a1df-bf3b2027ebba/11.04.2018-11.54.png" width="352" height="213" border="0" /></a>

 

[Kamolga]

=index(a3:b10,match(b1,b3:b10,1),1)

 

[Steve Swift]

Thanks so much for your help. It works perfectly

Have a great day.

 

[Kamolga]

You are welcome, thanks for the feedback