Excel Forum

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.