Vlookup Hacks: Hack #2 Range Lookups

File Download: https://www.excel-university.com/yt_m...

Learn Excel Fast:
https://www.excel-university.com/yt

In the first VLOOKUP hacks post, we talked about how the 4th argument impacts the sort order. But, there is more to uncover about this 4th argument. So, let’s pick up right where we left off.

So far, we understand that the 4th argument tells Excel if we are looking for a value between a range of values, or, if we are looking for an exact matching value. Its official name is range_lookup, and now it is time to dig into what it actually means.
Subscribe to blog and view all posts:
https://www.excel-university.com/blog/

• #education
• #excel_university
• #jeff_lenning