Excel Forum



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.