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.