Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/04/Find-numbers-between-range.xlsx

In this video I demonstrate how to find numbers within a specified range. I look at the following methods.

1) Excel's filter list functionality
2) The FILTER functions (Excel 365)
3) VLOOKUP approximate match - lookup value within a range of values.
4) XLOOKUP (Excel 365) - exact match or next smaller item, exact match or next larger item
------------------------