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...
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...
Prevent Images and Shapes from Resizing or Moving in Excel
Tutorial: How to stop Images and Shapes from resizing in Excel when you change the size of rows and ...



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.