Excel Forum
Similar Content
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...
Create an Index / Table of Contents worksheet
: To create an Index / Table of Contents worksheet to a workbook: 1) Add a new worksheet and...
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Mr Excel & excelisfun Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different Sheets


See Mr Excel and excelisfun do a 2 Criteria Lookup and Multiple Table Lookup From Different Sheets. Amazing Lookup Solution that:
1. Uses functions such as: INDEX, INDIRECT and MATCH
2. Used Defined Names
3. Keyboard Shortcuts for Navigating between sheets and creating Defined Names (Create Names From Selection)
4. Use INDEX function to avoid array formula Ctrl + Shift + Enter
Two Criteria Lookup and Multiple Table Lookup





Got a Question? Ask it Here in the Forum.