In this video I demonstrate how increase or decrease a value by a specified percentage. These types of calculations are useful when adding VAT or markup or applying a discount. You can download the featured file here.
Category: Excel Tutorial
Create a Multi Column Non-Contiguous Return Array Using XLOOKUP
In this video, I demonstrate how to create a non-contiguous return array when using XLOOKUP. The CHOOSE function does the trick here as you will see in the formula below. I created an array of index numbers {1,2,3} which correspond to the columns I have selected in the value 1, value 2 and value 3…
Read MoreHow 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 & INDIRECT. Click 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