If vlookup between two numbers

[andrew_milonavic]

Hi,

Is it possible for vlookup to return a cell greater than x but below y.

two conditions. name (a1) and number (b1)

Quick and dirty example below:

vlookup(a1 and b1) return test1



[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sally
[/TD]
[TD]750
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bill
[/TD]
[TD]Sally
[/TD]
[TD]Dave
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]500
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]501
[/TD]
[TD]1000
[/TD]
[TD][/TD]
[TD]test1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1001
[/TD]
[TD]1500
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1501
[/TD]
[TD]2000
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks

Andrew

 

[Joe4]

VLOOKUP can do approximate matches.
See:
https://www.techonthenet.com/excel/formulas/vlookup.php
https://exceljet.net/tips/how-to-use-vlookup-for-approximate-matches

 

[andrew_milonavic]

Thanks Joe. I'll have a look.