In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated formulas based on VLOOKUP, INDEX and MATCH, or nested IFs.
Comments at: https://exceljet.net/tips/how-to-use-...