VLOOKUP Hack #9: Partial Match
File Download: https://www.excel-university.com/yt_q...
Learn Excel Fast:
https://www.excel-university.com/yt
Let's say we want VLOOKUP to match the lookup value "North Region" with "North Region Subtotal" stored in the lookup range. We started this series by looking at the 4th argument. We know it can be TRUE or FALSE. FALSE means exact match and TRUE means approximate match. So, what exactly is an approximate match? Well, as you may have guessed, we'll dig into that, and, hack the 1st argument to accomplish our true objective: a partial match.
Subscribe to blog and view all posts:
https://www.excel-university.com/blog/