Dueling Excel 63


2 Criteria Lookup and Multiple Table Lookup From Different Sheets

DESCRIPTION

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

WORKBOOKS




Be the first to comment

Leave a Reply