Using The CHOOSE Function In Excel

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.

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply