Here are three examples of the use of Excel’s CHOOSE function:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Take a few minutes (5:02 to be exact!) and watch the video to learn about using the CHOOSE function. The third example is most interesting, using this function to create a reverse VLOOKUP. I’ll give you a sneak preview – the formula used is:
Information on array constants is here.