## Excel Vlookup Multiple Criteria

There are various methods of returning a value from a Table array based on more than one criteria. Vlookup is used when there is only one criterion (condition). In this tutorial, we will be discussing the method involving INDEX and MATCH.  Let us consider an example, see the below illustration: The Formula in C2 is: … Read more

## IF Formula with Four Conditions

Many insights derived from data analyses include determining the number of observations that meet specific characteristics. For example, an analysis of a person’s ideal automobile purchase may require that the price is below a specific dollar amount, the engine has a minimum horsepower rating, and the transmission to be automatic. While it is possible to … Read more

## Microsoft Excel Basic Formulas List

1. SUM This is the first Excel Function one should be familiar with. It basically performs the addition operation. The Syntax in which it is used is as follows: SUM (number1, [number2], …) Generally, arguments in square brackets are optional, the other ones are required. See it used in the example below   2. SUMIF … Read more

## How to Do a Vlookup Between Two Spreadsheets

Vlookup is a very useful Excel Function. Basically, what it does is ‘Look-up’ or searches for a value or text specified in a table (array) and returns a value or text from another column, also specified. One disadvantage of this Excel Function is that the value or text being looked up must be in the … Read more

## How to create a pivot table from multiple worksheets using Microsoft Excel 2016

A pivot table in its simplest form of a programming tool that permits its user to summarize selected columns and rows of data in a spreadsheet. Simply put is used in sorting information and used to break larger tables down into easier-to-use forms. In answer to the popularly asked question on whether a pivot table … Read more