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.
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
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.
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?
You are welcome!
great!
I prefer using the choose from a dynamic vector in excel.
EXCELlent!!!
excellent series!! where’s #15?
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
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!!!
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
you´re the best. you save my life on a daily basis…lololol tkss
You are welcome!
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…
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!
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
Try this video:
Excel Magic Trick 373: Randomize with No Repeats (Numbers or Words)
Another great vid! I can’t seem to find the 15th installment??
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
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?
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.
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.
@richpatino , here is the playlist with all the videos for lookup:
youtube.com/user/ExcelIsFun#grid/user/C7521C502A5C0EB1
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#grid/user/C7521C502A5C0EB1
@nmairena , it is not private. I am not sure what is going on. Try:
youtube.com/user/ExcelIsFun#grid/user/C7521C502A5C0EB1