Excel Lookup Series #1: VLOOKUP Function 1st Example
See how to use the VLOOKUP function to deliver a value to cell: 1) Find approximate value from column 2 of lookup table. 2) Find exact value from column 2 of lookup table. Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate. 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. Excel Magic Trick 167p2 IF function formula: 12 Examples! Excel Magic Trick 167p1 IF function formula: 12 Examples!
You are welcome!
That was it.. thanks.
Maybe the workbook is not caculating and is in Manual mode. You can change this by going to the Calculation Options drop-down in the Calculation group in the Formula ribbon.
yes, something like that.
I don’t know what you mean by “self populates”. Are you saying that the formula is not calculating, until you put it in edit mode and then hit enter?
Hi, I have ecel 2007, when I input the vlookup function in either 1 or multiple cells, the cell that had the vlookup formula never self populates. I have to click on the vlookup formula, then press enter and then the lookup happens.
what am I not doing?
You are welcome! I hope you do well on the test!
thank you very much man, this helped me for my Computer Applications (CS-121) test tomorrow. i didn’t understand VLOOKUP which is going to be a huge part of the test. instead of studying, i figured i would just search youtube last minute. and whaddya know! Voila! your video! thanks now i completely understand the VLOOKUP in just a few minutes, its like a crash course.
I understood that you said it in a positive sense! I thought it was cool what you said. I was trying to make a joke about my wife aways being mad at me! (She is not always mad, but when you are married it always seems that way!!).
oh srry mate.i was saying in positive sense.srry if it sound the other way around.English is not my mother tounge.All I was saying that she got a nice funny and good husband..:)
Best wishes to you!
Not my girlfriend, it’s my wife. How did you know that she is always mad at me?
hi..you got excellent funny skills..i am sure your girl friend love you madly..
with best wishes from pakistan
Not a god, just a guy having fun with Excel!
Hey, I already have 11 videos about Excel 2010 (100s more to come).
You should search for and watch this video title:
excelisfun Search for Excel Videos, Playlists & Download Workbooks
This video shows how to get the most out of the excelisfun channel. including finding the playlist with all the Excel 2010 videos!
you truly are an excel god. can’t wait for excel 2010 tutorials from you!
Search for and watch this video title:
excelisfun Search for Excel Videos, Playlists & Download Workbooks
where can I download these sheets? Please advise Thanks
EXCELlent!!!!!
I do not understand your question. Can you re-state your question?
HEY, HEY, HEY.
Hey, what is this.?
Hey , This is what it is
haha.
hi thanks for all your help do u have a webpage or something greetings
For the difference between lookup and VLOOKUP see these videos:
Highline Excel Class 07: VLOOKUP function formula 7 Examples
And
Highline Excel Class 42: Versatile LOOKUP function 10 Examples
I do not understand your 2nd question about functions.
what is the difference between lookup and vlookup…like when do you know which one to use?
another thing is in microsoft 03, are the functions given in any of the toolbars or do you have to memorize the format? :/
I am glad that it helped!
that’s very helpful!!!
Also, try this video tilte:
Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions