In this presentation, I demonstrate how to use the Vlookup function in Excel to give numbers in a column a range. You need to set a range table to execute this method. This Vlookup method is very useful in day to day office work. One of the usages of this method could be in making a master sheet of clients and assign them a range as per their monthly earning.
