Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up. Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated […]
Articles Tagged: Lookup Formulas
Troubleshoot VLOOKUP() Formula – The Common Mistakes
Excel’s VLOOKUP() function is notorious for returning wrong results, but it’s not the function, it’s the way you’re using it! Excel’s VLOOKUP() function finds a matching value in a list. It’s one of Excel’s most popular and misunderstood functions. It’s possible to enter the correct formula and still get the wrong result but with just […]
Learn to use VLOOKUP with MIN & MAX Functions
Learn to find Top & Least Sales Person Name with VLOOKUP function You can nest a function as the lookup_value argument with VLOOKUP, to return an item relating to the lookup_value function. In the pictured example, MIN and MAX are nested to return the name of the salesperson associated with those functions. The formula in […]
Learn to use Vlookup in Excel
Vlookup is one of the most popular look up functions in Excel. When you need to extract data from a table based on a particular value, you can use Vlookup to do that.