Partial vlookup match- contains part of the value

Please purchase the course before starting the lesson.

How to do a partial vlookup match so that for example the vlookup finds something like Anitha Bath when only searching for the word Bath or finding the correct phone number when you only know 8 or the 11 characters.

Back to: Vlookup Explained- 1 Hr > VLOOKUP Tips, Tricks and Uses