Share |

Excel Lookup Series #14: CHOOSE function

See how to use the CHOOSE function to select an item from a list. This function is useful if you want to type the lookup table into the function itself! In this Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

  1. ExcelIsFun
    June 29th, 2009 at 12:25 | #1

    Dear marjogeintje,

    Also, it may be helpful to search for and watch this video which shows how to use the excelisfun channel:

    Search For Excel Videos Download Excel Files excelisfun

    This video will show to to find all the complete Playlists for all the Series and various video collections that I have posted.

    –excelisfun

  2. xela12345234
    December 11th, 2009 at 08:07 | #2

    hey man,

    you’re videos have been tremendously helpful as i seek to sharpen my excel skills and land an entry level analyst job. very informative, easy to follow, clearly and distinctly spoken. Thank you very much.

  3. ExcelIsFun
    December 11th, 2009 at 14:32 | #3

    You are welcome!

    If you want to learn most of what Excel can do in a systematic order watch these two video series (playlists):

    1) Excel Basics (23 vids)
    2) Highline Excel Class (59 vids)

    Do you know how to find the playlists?

  4. ExcelIsFun
    December 16th, 2009 at 15:18 | #4

    You are welcome!

  5. GabiRav
    April 27th, 2010 at 20:53 | #5

    great!
    I prefer using the choose from a dynamic vector in excel.

  6. ExcelIsFun
    April 27th, 2010 at 23:01 | #6

    EXCELlent!!!

  7. MrChristian1a
    May 16th, 2010 at 02:46 | #7

    excellent series!! where’s #15?

  8. ExcelIsFun
    May 16th, 2010 at 19:00 | #8

    Search for and watch this video title:

    excelisfun Search for Excel Videos, Playlists & Download Workbooks

    Then go to the Lookup Series Playlist and you will find all the videos in this sereis

  9. rudedogg24
    June 23rd, 2010 at 15:01 | #9

    hey man. Your the best. I have a specific question i would like to ask you regarding my v-lookup. I have a V-LOOKUP that calculates people’s rates time the number of hours logged. i want to modify this so that if column c is Travel then half the person’s rate. Can you assist? PLEASE HELP!!!

  10. ExcelIsFun
    June 23rd, 2010 at 16:05 | #10

    I don’t really understand your question, but if it is how to add a 3rd column, try this video which has a few great examples:

    Highline Excel Class 07: VLOOKUP function formula 7 Examples

  11. lilianbrazilian
    August 24th, 2010 at 22:15 | #11

    you´re the best. you save my life on a daily basis…lololol tkss

  12. ExcelIsFun
    August 25th, 2010 at 00:24 | #12

    You are welcome!

  13. helplesssoul85
    September 23rd, 2010 at 10:53 | #13

    I have 2 say … (like everyone be4 me) u r de best!!!!!!!! …thanks a million for all de new tricks and the great explanations.

    I know it was asked be4 but I can’t find # 15 not even in your playlist does it stops at 14???

    but thanks again…

  14. ExcelIsFun
    September 23rd, 2010 at 13:47 | #14

    I deleted about 100 videos and re-did them.

    Search for and watch this video title:

    excelisfun Search for Excel Videos, Playlists & Download Workbooks

    This video tells you how to best use the excelisfun channel at YouTube!

  15. xR08x
    October 26th, 2010 at 06:15 | #15

    hey this video helped allot but do u know how to make it so that the names don’t repeat if u put it in 2 columns

  16. ExcelIsFun
    October 26th, 2010 at 13:45 | #16

    Try this video:

    Excel Magic Trick 373: Randomize with No Repeats (Numbers or Words)

  17. omiuno
    November 20th, 2010 at 05:33 | #17

    Another great vid! I can’t seem to find the 15th installment??

  18. ExcelIsFun
    November 20th, 2010 at 14:09 | #18

    Search for and watch this video title:

    excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks

    This shows how to find the Playlists, The Playlist has all the videos, including #15

  19. skyong87
    December 6th, 2010 at 18:37 | #19

    Hi there, can i know the solution to solve my following question?
    A B  C
    1. 124-45-D88 = 20
    2. 222-36-D88 = 30
    3. 1660-12-D88 = 15
    How can i add all de values together for 1, 2, 3 as their last reference (D88) are the same as if de references all are in one column only?

  20. ExcelIsFun
    December 6th, 2010 at 19:39 | #20

    I do not understand your question. Try posting to this site:

    mrexcel[dot]com/forum

    Then send me the link to your question. This is site is MUCH easier to use to help solve Excel questions.

  21. richpatino
    November 7th, 2011 at 07:18 | #21

    I know there is really more than 15, but I must ask the following question since I am ___.

    Where is Excel Lookup Series #15?

    Either way, this made for a great Sunday.

  22. ExcelIsFun
    November 7th, 2011 at 13:22 | #22

    @richpatino , here is the playlist with all the videos for lookup:

    youtube.com/user/ExcelIsFun#grid/user/C7521C502A5C0EB1

  23. nmairena
    January 17th, 2012 at 04:20 | #23

    Where is Excel Lookup Series #15?
    The following link tells me: “Incorrect parameters, please try again.” / “You are unable to view the playlist because it is marked private.”

    youtube.com/user/ExcelIsFun#gr­id/user/C7521C502A5C0EB1

  24. ExcelIsFun
    January 17th, 2012 at 14:25 | #24

    @nmairena , it is not private. I am not sure what is going on. Try:

    youtube.com/user/ExcelIsFun#grid/user/C7521C502A5C0EB1

  1. No trackbacks yet.

CommentLuv badge