VLOOKUP Function with TRUE for Approximate Matching
For 99% of cases, you'll use FALSE as the final argument of the VLOOKUP function to do exact matching. In this video though, you'll learn about the use for the TRUE final argument of the VLOOKUP for approximate matching.
It's really useful for things like adding interest rates to a list of account balances, which lie in bounds but do not match exactly to the interest rate bands.
This is lesson 6 from my free course: Advanced Formulas 30 Day Challenge
Sign up for free here: https://courses.benlcollins.com/p/adv...
Read more at: https://www.benlcollins.com/spreadshe...
Watch video VLOOKUP Function with TRUE for Approximate Matching online, duration hours minute second in high quality that is uploaded to the channel Ben Collins 10 March 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 5,851 times and liked it 57 visitors.
