# Formulas

## Copy Excel Formulas Without Changing Cell References

Would you like to copy your Excel formulas from one place to another without the cell references changing? Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell

## Excel IF Formula: Simple to Advanced

The IF function is one of Excel's most common Functions The IF formula performs a test and returns a value depending on the outcome of the test. The test it performs can be simple or complex depending on the problem at hand. It's one

## Reset Week Number Every Month (start from Week # 1 every new month)

WeekDay & WeekNum Functions Explained Excel Reset Week Number Every Month In this tutorial I show you two ways to reset the week number to start from 1 at the beginning of every month. 1st case: We use Excel's WEEKNUM function to

## Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets: VLOOKUP & INDEX MATCH in Excel In Excel, it’s relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using only one formula? In this tutorial, I'll show you

Find Header based on Lookup Criteria in Matrix (Unique matrix values) - scroll down for non-unique method  In this tutorial I show you the answer to one of the questions that was asked some time ago on the Mr. Excel message board (the sample

## Lookup multiple criteria in rows or columns

The Complete Guide to INDEX & MATCH CHAPTER 2: Lookup multiple criteria in rows or columns Some reports involve the need to find a value from a source table using multiple criteria in rows and columns. In this example, we have a

## Excel Reverse Matrix Lookup

Are you familiar with INDEX MATCH? If you're familiar with Index and Match you know how to solve a matrix lookup problem. You want to find a value inside the matrix by looking up the row and column headers. What happens though when it's

## Excel WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidays

Excel's workday function is great when you need to calculate an end date based on a given number of working days - which means you need to exclude weekends and holidays. Some examples are: creating a project timeline creating a reporting timetable Excel's standard

## VLOOKUP and HLOOKUP Basics

VLOOKUP & HLOOKUP for Dynamic Lookups These two functions are easy to write, understand, and they’re a major time-saver for simpler lookups. The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns.

## INDEX & MATCH for Flexible Lookups

The Complete Guide to INDEX & MATCH INDEX & MATCH for Flexible Lookups Contents CHAPTER 1 The Basics of INDEX & MATCH CHAPTER 2 Lookup multiple criteria in rows or columns