Excel Forum
Similar Content
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Dynamic Charts in Excel - The Easy Way
Tutorial: How to create dynamic charts that update automatically when new data is added to Excel. T...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.