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:

=VLOOKUP(A15,CHOOSE({1,2},D2:D6,A2:A6),2,0)

Information on array constants is here.

Related Post

Free Download!

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

, ,

No comments yet.

Leave a Reply