Search Site For: Bet you can't stump us. Try it. Search for anything!

Please Share ...

Related Videos

nussentials nussentails arthritis stabilized rice bran phil mims cenay soy candles weight management cardiovasular diabetes arthritis joint pain energy drink immune function health and wellness children incorporated gout perthes disease nussentials hero book chronic arthritis pain

nussentials
Items of Interest

Related Videos

nussentials nussentails arthritis stabilized rice bran phil mims cenay soy candles weight management cardiovasular diabetes arthritis joint pain energy drink immune function health and wellness children incorporated gout perthes disease nussentials hero book chronic arthritis pain

Please Share ...

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!

Author		ExcelIsFun
Length		07:58
Rating		4.724138
Views		115092

Tags		Excel VLOOKUP function approximate value or exact column name data validation Mike Gel Girvin Highline Community College

Video Comments

ExcelIsFun on (November 30, 1999 at 12:00 am)

Watch this video to learn how to use excelisfun channel: excelisfun Search for Excel Videos, Playlists & Download Workbooks To Subscribe: click the button that says Subscribe in the upper right corner of this screen.

nitekode on (November 30, 1999 at 12:00 am)

How do i subscribe to your channel!! you are amazing and teach me in 10 mins what 3 books and days/weeks of frustration could not!!!

ExcelIsFun on (November 30, 1999 at 12:00 am)

You are welcome!

andrewbwerner on (November 30, 1999 at 12:00 am)

That was it.. thanks. :)

ExcelIsFun on (November 30, 1999 at 12:00 am)

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.

andrewbwerner on (November 30, 1999 at 12:00 am)

yes, something like that.

ExcelIsFun on (November 30, 1999 at 12:00 am)

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?

andrewbwerner on (November 30, 1999 at 12:00 am)

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?

ExcelIsFun on (November 30, 1999 at 12:00 am)

You are welcome! I hope you do well on the test!

viperpulse on (November 30, 1999 at 12:00 am)

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.