VLOOKUP Hack #9: Partial Match

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.
Written tutorial and sample file:
https://www.excel-university.com/vlookup-hack-9-partial-match/
Subscribe to blog and view all posts:
https://www.excel-university.com/blog/

Видео VLOOKUP Hack #9: Partial Match канала Excel University