Excel Forum



Excel Magic Trick 356: Dynamic Two-Way Look Form Different Workbook


See how to create a Dynamic Two-Way Look Form Different Workbook. See these topics:
1.IF function formula to retrieve data from a different workbook
2.SUMPRODUCT function to count non-blank cells
3.OFFSET function to create Dynamic Ranges
4.Data Validation with Dynamic Named Ranges
5.INDEX and MATCH functions for two-way lookup.





Got a Question? Ask it Here in the Forum.