Excel Forum



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.