|
Featured Tutorial
Featured Macro
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
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