by John MacDougall | Nov 20, 2016 | Tips
Get The Completed Workbook Looking up a value based on one criteria Let’s say we have a table with employees and their total sales and we want a formula to return the total sales based on the employee. Now, if we want to get Allison’s...
by John MacDougall | Apr 16, 2016 | Formulas
Get The Completed Workbook VLOOKUP is one of the most useful functions in Excel, but after learning its use most people quickly realize some of its limitations. It only allows you to look up items to the right of a column with the criteria you’re looking up. It...
by John MacDougall | Apr 16, 2016 | Formulas
Get The Complete Workbook How do you use VLOOKUP with multiple lookup criteria? In its basic form, VLOOKUP can only look up data based on one criteria. To get around this, you could add in another helper column that concatenates the different criteria together and...
