How to do a Vlookup in Excel
This video will teach you how to master the Vlookup in Excel.
How to use a Vlookup to find approximate numbers in a net promoter score range
This video will teach you how to use a Vlookup formula in Excel when you do not want the range lookup to be false. Normally you want false on the last argument of the vlookup because you are trying to find an exact match. When you are looking for numbers within a sorted range lowest to highest. I explain how to segment your customers in the net promoter score which assigns numbers between 0 and 10. 9 and 10 is a promoter. 7 and 8 are Passive. 0 to 6 are detractors. Find out more about net promoter scores here.
How to combine the VLOOKUP and IF functions in Excel
In this video, I will teach you how to determine whether an individual made their sales goal, and if that is true, then calculate the commission rate using the Vlookup function in Excel to determine their total sales commission.