How to lookup given value from a range (with upper with lower limit)

[Sub zero]

Find the value of 2500 from below table

ColumnA | Column B
1000-2000 | 78
2001-3000 | 56
3001-4000 | 78
4001-5000 | 456

 

[Becky]

This sounds like a homework / study question, is that right?

 

[Sub zero]

This sounds like a homework / study question, is that right?

Asked in an interview.