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.