Excel Forum
Similar Content
3D References - Formulas that Reference Multiple Sheets at Once in Excel
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...
Helper Slicer Visual Analysis Trick for Excel
Tutorial: How to make buttons to visually analyze any data set in Excel. This allows you to click a...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
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 357: Excel Efficiency: Proper Data Setup, Then Lookup From Different Sheet


Move football betting data from master sheet to individual sheets when the data is not setup properly. See how to:
1)Setup data correctly
2)Create Primary Key for lookup when there are duplicates in lookup column using new column and Ampersand
3)Use INDEX and MATCH functions to lookup value on a separate sheet
4)Create template that can be easily copied to new sheets
5)Copy worksheet with one click





Got a Question? Ask it Here in the Forum.