### Excel Magic Trick 1137

Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP DESCRIPTION See how to (00:08) Intro. (01:21) Approximate Match with VLOOKUP. (02:20) Approximate Match with AGGREGATE (to simulate logic that is present in DAX formula). [Read More >>>]

### Dueling Excel 029

Existing Customers In Prospect List? DESCRIPTION See Mr Excel and excelisfun compare a customer list and prospects list to see if customers are in the prospects list. Then remove the duplicates. See the MATCH, VLOOKUP [Read More >>>]

### Excel Magic Trick 1134

IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples DESCRIPTION See how to assign product and sales categories using various methods: Overview (00:44) Overview (01:30) IF and Hard Coded Values: Violates Excel’s [Read More >>>]

### Excel Magic Trick 1133

Aging Accounts Receivable Reports: PivotTable & Unique Identifier DESCRIPTION See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records: (01:49) Days Late Helper Column Formula: [Read More >>>]

### Dueling Excel 024

VLOOKUP, MAX, Boolean, IF, Which is Best? DESCRIPTION See Mr Excel and excelisfun throw out 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas. Which one do you like? [Read More >>>]

### Excel Magic Trick 1129

DESCRIPTION See how to create Ageing Accounts Receivable Reports using Slicer, Excel Table Feature and formulas: (00:09) Overview (01:05) Text Formula For Reporting Categories in Lookup Table (01:59) Days Late Formula. The correct formula for [Read More >>>]

### Excel 2013 PowerPivot Basics 03

DESCRIPTION See how to replace VLOOKUP with Excel 2013 Data Model and Relationships. See how to get two or more tables into a PivotTable Field List: (00:11) Get Two Tables into an Excel 2013 PivotTable [Read More >>>]

### Excel 2013 PowerPivot Basics 01

DESCRIPTION Basics of PowerPivot: Why PowerPivot?, Add to Data Model, Relationships, Calculated Column, Calculated Field, Build report with PivotTable based on Data Model: (00:22) Smartest People with PowerPivot (01:31) Which Versions of Excel 2013 contain [Read More >>>]

### Excel Magic Trick 1107

DESCRIPTION See how to do a VLOOKUP to a different Sheet using: 1. Sheet References 2. Defined Names 3. Table Formula Nomenclature (Structured References) WORKBOOKS

### Excel Magic Trick 1102

DESCRIPTION See how to string three VLOOKUPs and IFERROR together to do a lookup from three tables in order to rank movies. WORKBOOKS