Category: Excel Tutorial

Excel TutorialTutorial

How to Perform Fuzzy Match or Partial Match Lookups in Excel

This video demonstrates how to perform fuzzy or partial match lookups in Excel.  There are two scenarios where you might need to use a partial match: When the lookup value is partial When the lookup table contains partial strings.

 

VIDEO TRAINING - LEARN AT YOUR OWN PACE

DEEP DIVE INTO LOOKUP FUNCTIONS - XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, IFERROR, ISNA, IFNA, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN & INDIRECTClick here to enrol

THE MS ACCESS FOR BEGINNERS' COURSE - Click here to enrol


FREE STUFF
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf 

 

 

The video covers both scenarios. In Office 365 we can use XLOOKUP and…

Read More