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

Joined
May 22, 2018
Messages
4
Reaction score
0
Find the value of 2500 from below table

ColumnA | Column B
1000-2000 | 78
2001-3000 | 56
3001-4000 | 78
4001-5000 | 456
 
This sounds like a homework / study question, is that right?
 
Back
Top