The many uses of VLOOKUP
Vlookup can be used in a variety of areas and is therefore a very important function that is well worth getting to know. Its uses include: <ul> <li>Joining/ merging databases and tables e.g. attach employee names to their salaries, address details etc</li> <li>Finding missing items (useful for reconciliations)</li> <li>Comparing 2 columns (useful for reconciliations)</li> <li>Extract information from data to be used regularly in reports</li> <li>Let Excel guestimate an answer</li> <li>Create categories for employee performance, grouping of sales, grouping employees into age brackets</li> <li>Age invoices, stock and debtors into bands- aging anything</li> <li>Sales commission bands</li> <li>Tax bands</li> <li>Different interest rates at different bank balance levels</li> <li>Create costs that effect certain months depending on business activity</li> <li>Calculate step up costs and fixed costs in a financial model</li> </ul> Once you understand how VLOOKUP works, you will also understand better how Excel's more complex functions work and you will find that the other ones are a little easier to learn. <strong>To see the full course contents click <a href="https://online-excel-training.auditexcel.co.za/course/intermediate-excel-course/">here</a>.</strong>