Excel - Find Numbers Between Range | FILTER & VLOOKUP to Find a Value that Falls Between a Range

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
------------------------

[jptsyoshida]

Great filter formula option! I saved me at least few days of manual comparison! Thank you!

[dan]

Exactly what I was looking for with the Xlooup.

[IvanCortinas_ES]

Thank you for the explanation. FILTER is a real gem. A very good explanation.

[lisadailey]

Thank you! I just spent 4 hours trying to find how to do this, I knew my table was wrong, argh! Thank you, thank you.

[patrickschardt]

Easy to follow and a fantastic tutorial as always

[lethanhha]

Thank you very much, it' was all I need.

[zagfat]

GREAT. THANK YOU. Learned some useful tricks.

[svnwrnchful]

In the 2nd style of filtering, the filter function. Is there a way to add a sort function of the dollar amount in the formula to descend from largest to smallest via the dollar amount ?

[Smilinreap]

the -1 on xlookup, how did I never use that in my many years in Excel. Thanks for the video.

[davidsyes]

Is it possible to use on the Filter Table the same setup of Min/Max as used on the adjacent table?

Then, with filtering still active, the user could just type in the min/max.

Or, does the Filter feature not respond to out-of-table references?

[parantapkumar]

Sir, How to filter if there are multiple rows in Min Max?