Excel Lookup Series #1: VLOOKUP Function 1st Example

[vozer2020]

Damn dude,, ;) ur FaNtAsTic0 really thx a lot that is really what I need

[AmyVu68]

Thank you so much for your tutorials. I have a job interview that requires me to do Vlookup and PivotTable, I am very confident I will get the job. Thank you. Keep up the great work :)

[ExcelIsFun]

@AmyVu68 , Cool - I am glad that the videos help!

[ariasd2006]

Nice tutorial. I’m a college graduate, and even working now, this video really helped. Thanks a lot!

[ExcelIsFun]

@ariasd2006 , you are welcome!

[lozzabythway]

Thankyou!! So much for this video!! I can now pass my course!!! I love your vids so much!!

[ExcelIsFun]

@lozzabythway , I am glad that you like the vids!

[steevyboy601]

How can I set a service charge?

[AnnihilationXable]

Hey, thanks so much for the tutorial, I have an Excel exam tomorrow and I don't think my teacher did a very good job explaining this. Now I'm certain I'm gonna do better than everyone else, thanks again!!

[ExcelIsFun]

@AnnihilationXable , great! Good luck with doing EXCELlently on your exam tomorrow!!!

[balachand1981]

hi how do i download this specific video from your site, i tried finding it, but could not get it. pls do tell

[maearly260]

this guy sounds like Kyle Cease

[ehiirianan]

WOW!!! I am extremely grateful to have found you! i have been searching all over for excel tutoring. you are a tremendous help and blessing. Thank you!

[tongkaixiong]

Thanks for you video; however, Can we use the vlookup to lookup at the "lookup value" that more than one cell. Such as not only one cell as "lookup value", but many cell as "lookup value"?

[ExcelIsFun]

You are welcome!

[Pavel1088]

Y___Y, like like, very funny and useful ! Thanks !

[ptbako1]

thanks



[ExcelIsFun]

You are welcome!

[suruchigupta2k3]

Thanks once again!

[ExcelIsFun]

You are welcome!

[suruchigupta2k3]

Hi, I Cannot find the workbook for this. Please let me know the link ... Thanks!

And thanks a lot for these videos.. they are just awesome.

[ExcelIsFun]

try:

people.highline.edu/mgirvin/Ex­celIsFun.htm

[birgeddegrib]

@suruchigupta2k3 - a list of .xls files as long as your arm . Also a lot of pdf's and " Excel2007IsFun!.doc Book (Free book!) " . regards

[ExcelIsFun]

I am glad it all helps!

[McBirdec]

How do you create a huge random data set? I tried using RANDBETWEEN but don't know how to turn off the rand once I get my numbers

[ExcelIsFun]

After you create the numbers, you have to copy them, then Paste Special, Values.

[andyfreeman6942]

Cheers, you have just made me look very clever in my bosses eyes hehe

[ExcelIsFun]

EXCELlent!

[sysunws]

thank you soooo much for your work in which contributes a great amount of useful excel skills to people like me. I appreciated man. thank you so much once again.

[ExcelIsFun]

You are welcome!

[LiamDelicate]

hi. awesome videos. is it possible to use VLOOKUP for income tax calculations in Excel?

[ExcelIsFun]

Here is a video:

Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example

Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Example

[MrBboyboomer]

man you are a great teacher! thank you so much!

[ExcelIsFun]

You are welcome!

[philipelva]

that's so cool. I think this would help me preparing for my exam :) thanks

[ExcelIsFun]

I am glad that the video helps!

[technocastle69]

thanks! you made excell fun, haha :)

[ExcelIsFun]

You are welcome!

[areibim]

I am having a problem with the 2nd step of case one in tutorial 7 of the MS excel 2007 workbook that requires me to enter a lookup function to insert the Type of product, model and price for each product value. Any tips?

[ExcelIsFun]

No. I do not have that book. Did you ask your teacher?

[ExcelIsFun]

Try Mr Excel Message Board.

[generousboii]

thnxx.........:)



[ExcelIsFun]

You are welcome!

[ExcelIsFun]

Try the Mr Excel Message Board

[ExcelIsFun]

I do not know. Try Mr Excel Message Board.

[ExcelIsFun]

I do not know. Try Mr Excel Message Board.

[ExcelIsFun]

I do not know. Try Mr Excel Message Board.

[ExcelIsFun]

I do not know. Try:

mrexcel[dot]com/forum

[pamela1977]

you are amazing! i have been struggling with this on the case problem in my excel class. thank you so much for taking the time to show everyone! i did it exactly like you said and applied it to my problem and it worked like a charm:)

[ExcelIsFun]

You are welcome! I am glad that it helped!

[yourheartvsmine]

THANK YOU THANK YOU!



[ExcelIsFun]

You are welcome!

[g9891481183]

Nice....

[ExcelIsFun]

I am glad that you like it!

[upc04539]

Very nice and useful. Simple and complete explanations although your intonation is near childish ;-P Thumbs up for YouTube and Google, infinites databases of knowledge.

[pugmanic7]

Mate you are an absolute legend!! Someone please buy this man a beer (y)

[ExcelIsFun]

I am glad that the videos are helpful - I'll have a dark beer, please!

[MrSunilmanjunath]

how do i download the excel sheet you are referring to?where is the link?

[ExcelIsFun]

all the way at the bottom of this link:

people.highline.edu/mgirvin/Ex­celIsFun.htm

[broccetti12]

Thank you soooooo much! This is the easiest way to learn this :)

[ExcelIsFun]

You are welcome!

[swapnil312]

@ExcelIsFun :i tried to learn it throw so many other post on google bt failed bt this one proved to b simply best ,easiest n quickest way...thanks 4 uploading this vedio

[ExcelIsFun]

You are welcome!

[geniuswu06]

Excel genius, would you mind infoming me the website address so I can download workbook.

BTW, the video is amaziiiiiiiiiiiiiiiing~

[ExcelIsFun]

people[dot]highline[dot]edu/mg­irvin/ExcelIsFun.htm

or search for 'excelisfun', then go to the channel link and watch the video that auto plays - it shows a bunch of useful tricks for getting the most out of excelisfun channel at YouTube.

[geniuswu06]

@ExcelIsFun

thx~~helpful

[ExcelIsFun]

You are welcome!

[hemendrajebaliya]

awesome help keep doing it thanks

[ExcelIsFun]

You are welcome!

[gingersnaps1105]

i have just discovered your tutorials after rummaging through a few and yours is by far the best!! one issue though. i am having difficulty finding the coressponding workbook for the lookup tutorials. i don't see it on the website. can anyone help me?? i'd appreciate it. thank you!!

[ExcelIsFun]

Search for excelisfun", then click on the Channel link. There is a automatic video that will play and show you how to download.

[gingersnaps1105]

@ExcelIsFun Thank you so much! I appreciate your fast reply. You are an excel genius and you respond almost immediately. Are you human?!?! ;)

[ExcelIsFun]

Yes I am human. But really, I am just a guy having fun with Excel!

[gingersnaps1105]

@gingersnaps1105 that's great that you have found joy in using excel and teaching others..and as a secondary result, i think many of us are enjoying using excel too!!

[ExcelIsFun]

EXCELlent! I am glad that the videos help!

[gganiaa]

You're so fun and excited about Excel that I actually start consider this program interesting :D

[ExcelIsFun]

Woo Hoo! I am glad to hear that. Knowing Excel can help at work a lot!

[kashewz]

i love how you pretty much covers the most randomest questions. "oh shit, what happens if i forgot my name??" no worries, F3!!!

[ExcelIsFun]

I am glad that the videos help!!

[haon2099]

awesome video! HELPED ME OUT LOADS!!!

[ExcelIsFun]

I am glad that it helps!

[RevealUsYourLove]

Sorry I've got your name wrong, mike! It's 1.30am here now and I need that question answered soon. Btw, I wanna use John smith and Andrew as a lookup.

[RevealUsYourLove]

John, I have a question on the ability of excel to do multiple lookup source. I'll try to give and example:

Cell A is name (A1) : 3 John Smith (A2, A3, A4)

Cell B is middle name (B1): Peter (B2), Nick (B3), Andrew (B4)

Cell c is score (c1) : 178 (c2), 233 (c3), 145 (c4)

What is the score for John Andrew Smith?

Is excel able to do such lookups?

do you have a tutorial on that?

Thank you!

[ExcelIsFun]

I do not understand your question. YouTube is a hard site to have discussions about Excel. THE best site is:

mrexcel[dot]com/forum

After you post to this site, please send me link, and I will answer. However, this site has 1000s of Excel experts that will also try to answer (good thing).

I look forward to your question.

[ExcelIsFun]

Send link by YouTube e-mail or excelisfun at gmal.

[eapeters12]

you are an amazing teacher!!  thank you!

[ExcelIsFun]

I am glad that the videos help!

[p03751]

@eapeters12 I Got promotion this year , by getting help from Mr. Excel.

Thank you Sir, for your support and time to internet users.... May God bless you.

[ExcelIsFun]

You are welcome!

[pjain23]

Is "Excel is fun "on facebook?

[ExcelIsFun]

Yes. Search for "excelisfun" and you will find it.

[Ahmad2times]

Thanks for all the video on VLOOKUP, great!

Thanks to you, excel is no longer strange to me =)

[ExcelIsFun]

I am glad that the videos help!

[seasoul1979]

Thanks for this video!

[ExcelIsFun]

You are welcome!

[fortunate0]

Thanks

Really are doing very nice work plz can you share your web from where i down load this work book

Thanks again

A.Rehman

[ExcelIsFun]

Search for:

excelisfun

Then go to the channel and watch the video that plays to see how to download the workbooks.

[Baobao531]

Go over you uploads again, learned even more than before. Many thanks for sharing.

[ExcelIsFun]

You are welcome!

[rommelcjimenez]

thank you very much for uploading such tutorial lessons. i really learned a lot. Your ways are very simple and not difficult to follow.

[ExcelIsFun]

You are welcome!!

[spidolster]

Man.. you are a genuine savior.. Please keep up the good work..

[ExcelIsFun]

I am glad the videos helped!

[cumnkisme]

you are the best, thanks for all the the vids u posted. very helpful! everytime i have problem in office that concerns excel i immediately search for your videos. Thank you so much again. god bless. you are the best teacher!!! :D

[ExcelIsFun]

I am glad that the videos help!

[rodeocarli01]

I have created a worksheet with several different vlookups as well as data validation. I am having trouble with it saving. Is there anything I can do? Or do you think there are too many references that it's just getting locked up? Please help. Thank you!

[ExcelIsFun]

Unless you are using a million rows in each lookup, several lookups should not freeze the computer.

[rodeocarli01]

I have created several different vlookups and data validation in one workbook on 4 different worksheets. I am having trouble with it saving. Is there something I can do so it won't freeze anymore? Or do you think it may have too many refernces so it gets locked up?

[oisraelc25]

hello just want to know if you have a webpage of all your examples thanks

[ExcelIsFun]

Search for and watch this video title:

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

[Baobao531]

You are the best, as always.......

[ExcelIsFun]

Just a guy having fun with Excel!!

[pramodrekhamys]

There cannot be any better way to learn excel than here. Thank you very much. This has really helped me a lot.

[ExcelIsFun]

You are welcome!!

[pasuka08]

My formulas become much simple after these videos!!

[ExcelIsFun]

I am gld that they help!

[douginamerica]

You are the best. I subscribed and everyone else should too. I hope these videos stay on here forever. I have so much to learn!

[ExcelIsFun]

I am glad that they are helpful!

[fbi1980m]

Thanks for the video.

[ExcelIsFun]

You are welcome!

[welcomeautumn]

Dear ExcellsFun

When choosing between Approx and Exact for the range_lookup, where does it tell me that TRUE is 1 and FALSE is 0? I suppose I will remember it now for future reference or if in doubt could always type the word out.

Apologies for my basic question and thank you for your efforts to help others.

[ExcelIsFun]

No Apologies for basic questions! It does not say that anywhere, you just have to remember it.

[Mishkafofer]

The thing that bugs me is that Vlookup is looking for names (A,B,C) only if its on the right, if you transfer the range of the grade (The letters: ABCD) to the left, the function will not work. I don't understand why Vlookup looks only to the right.

[ExcelIsFun]

Try these videos for a solution:

Mr Excel & excelisfun Trick 19: VLOOKUP to Left (MATCH & INDEX or LOOKUP)

Excel Magic Trick #27: VLOOKUP won't work: use INDEX & MATCH

[Mishkafofer]

@ExcelIsFun In your opinion, what is best? lookup or index&match? currently index&match seem more powerful because they don't got Vlookup limitations.

[ExcelIsFun]

INDEX and MATCH can do many more things than VLOOKUP. Hands down INDEX and MATCH are more powerful than VLOOKUP. But VLOOKUP is used more often because most tables are vertical and have the lookup value in the first column.

[krisnatarajan]

Thank you. U are great!

[ExcelIsFun]

I am glad that the video helped!

[ruminatora]

which function is most useful to let excel look for the closest number??? like 10,6 it gets you 10,7 instead of 10 when using VLOOKUP

[ExcelIsFun]

Search for:

Excel Magic Trick 319

That video shows how to do a lookup when the lookup table is in descending order and you are looking for the smallest value that is greater than than or equal to the lookup value.

[burningeko]

thankyou, you saved my ass. ive been trying to figure out how to place a unique id that can link workbooks and auto fill rows for about a week now. perfect, elegant, simple, well explained.

from one educator to another i salute you

[ExcelIsFun]

EXCELlent!! I am glad that the video helped!

[Maurau]

I congratulate brilliant teacher

[ExcelIsFun]

Thank you! I hope the video was useful.

[waseemakhlaq123]

i have a Excel Sheet which A colum have the different name with duplicate and the next colum B have a value. i want to create a formula(vlookup) which i see the value of infront of it and not remove duplicate becz there colum b have different value please tell me

[ExcelIsFun]

Try this video:

Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column

[Macdker]

That's a gd revision for my ICT test tomorrow !!!

[FoxOnTheRoxxx]

I'd just like to say thanx man.

This will hopefully get me a better paid job

thanx again

[ExcelIsFun]

For an even better paying job, you can watch my Excel Basics Series videos 1 to 23. Just search for 'Excel Basics'.

[Businesslntelligence]

WELCOME haha come on

[nitekode]

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]

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.

[andrewbwerner]

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]

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]

yes, something like that.

[ExcelIsFun]

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]

That was it.. thanks. :)

[ExcelIsFun]

You are welcome!

[viperpulse]

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.

[ExcelIsFun]

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

[strangr0001]

hi..you got excellent funny skills..i am sure your girl friend love you madly..

with best wishes from pakistan

[ExcelIsFun]

Best wishes to you!

Not my girlfriend, it's my wife. How did you know that she is always mad at me?

[strangr0001]

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..:)

[ExcelIsFun]

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!!).

[peacestation3]

you truly are an excel god. can't wait for excel 2010 tutorials from you!

[ExcelIsFun]

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!

[myunlu1]

where can I download these sheets? Please advise Thanks

[ExcelIsFun]

Search for and watch this video title:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[takacicolenxxx]

HEY, HEY, HEY.

Hey, what is this.?

Hey , This is what it is :P

haha.

[ExcelIsFun]

EXCELlent!!!!!

[oisraelc25]

hi thanks for all your help do u have a webpage or something greetings

[ExcelIsFun]

I do not understand your question. Can you re-state your question?

[chatlovesyou]

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? :/

[ExcelIsFun]

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.

[lordaVadera]

that's very helpful!!!

[ExcelIsFun]

I am glad that it helped!

[kingasports1685]

The turtorial was very informative; i did a ton of searching on something i was looking, ended up having to ask 'an expert' to figure out that vlookup was the way to go. Then i found your video!

Although i must say the sound effects you make are a bit weird at least its motivational and like i said very informative. Still working on some tricks for a stat sheet.

Thanks a ton!!!!

[ExcelIsFun]

You are welcome. If you want to see more videos, I have over 100 Excel statistical videos and about 80 VLOOKUP videos. Search for and watch this video title to learn how to find exactly the video you want:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[kingasports1685]

wont be on long today, will check ur vid's tomorrow after work, any idea on how to vlookup for two different spreadsheets if one isnt in one of the sheets? im trying to generate through 10 yrs worth of players and when one player isnt in one year it comes up with an error message.

I will check over the videos for more help tomorrow! thx :)

[ExcelIsFun]

Search for and watch this video title to learn how to find exactly the video you want:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[ExcelIsFun]

Also, try this video tilte:

Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions

[09278751957]

tnx so much.. now i know

[ExcelIsFun]

EXCELlent!!!!

[gerretl]

This series is superb. Really easy to follow, and an enthusiastic teacher to boot.

Thanks

[ExcelIsFun]

You are welcome!

[Metrofabelectric]

I am just one of the many people who benifiting from Excellsfun. Thank you very much. More power!

[ExcelIsFun]

You are welcome!

[BrazucaNY]

wow you can rely explain this nice... Thank you.

[ExcelIsFun]

You are welcome!

Keep watching the series becasue there are lots more examples of VLOOKUP and other lookup functions!

Not Only That, but if you watch this video title, it will show you how to search for the videos that you want:

excelisfun Search For Excel Videos and Playlists & Download Workbooks