Excel Forum
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 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to use the CHOOSE Function To "Mash" Join Columns from different sections of the spreadsheet in order to create one lookup table. CHOOSE uses an array constant to do this trick. Aladin, barry Houdini, DonkeyOte at Mr Excel Message Board. See the functions VLOOKUP and INDEX and MATCH





Got a Question? Ask it Here in the Forum.