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…

Comments Off on Excel Vlookup Multiple Criteria

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…

Comments Off on IF Formula with Four Conditions

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…

Comments Off on Microsoft Excel Basic Formulas List

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…

Comments Off on How to Do a Vlookup Between Two Spreadsheets