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

[kayode98]

You are awesome men. You increased my reputation and make me the go to guy on job.

[ExcelIsFun]

@kayode98 , cool! I am glad to help! Congrats on being the Go To Guy!!!

[Pilberstein1]

Also just got your book on amazon. Hope you get lots of sales...

[ExcelIsFun]

@Pilberstein1 , thank you very much for your support!!!!

[Pilberstein1]

wow. Amazing work. I don't think of ever seen a resource quite like this. Your videos are actually lot of fun to watch. For once, I believe I just might be able to master excel. You're the best!!!!!

[ExcelIsFun]

@Pilberstein1 , I am happy to hear that - i am glad that you like them!!

[babyfcs88]

geez.. you are an expert... I just love learning it here :) great job !!

[ExcelIsFun]

I am glad that you like them!

[tuberubering]

Hi there.

Question: Could we type "column" prior to the column number in our "tax" table array?

Thanks! :)

[ubersuperbatman]

I love you!

[ExcelIsFun]

Cool! Since love is the most important thing in the universe (Excel is about 3), that is a huge compliment! I am glad that you liked the video!

[BartekMaliszewski]

Please don't jump with sceen-capture, it confuses...

[kashewz]

i've been watching some of your vids, but i still have a question that still haven't exactly addressed what i've been looking for. is it ok if i send you a personal message with my situation / question, and you can refer me to which video you'd recommend that i watch? i'm not requiring you to give me like a total personal tutorial, just a direction on which video to watch, and i'll learn by myself...? thanks.

[ExcelIsFun]

Send question by YouTube e-mail.

[chowman007]

Hi, am new to excel and learning a lot. Do you have any videos on how one can use data from one sheet, pasted to another sheet to compute? Your assistance will be greatly appreciated.

[ExcelIsFun]

Try this video;

Highline Excel Class 06: Worksheet & Workbook References

[sdubey]

Hi Mike, Thanks a ton for uploading the vedios and excel files..They have helped me a lot to improve my excel skills.I love the way you teach. U r the best teacher i have come across ever!

I thank u from the bottom of my heart for being so helpful to others..I admire u a lot...God Bless u!

Regards

[ExcelIsFun]

You are welcome!!!

[renie1981]

YOU ARE AN EXCEL ANGEL. THIS IS SO UNBELIEVABLY HELPFUL! ESPECIALLY FOLLOWING YOU WITH YOUR WORKSHEETS. PEOPLE LIKE YOU GIVE ME HOPE IN THE HUMAN RACE! LOL. SERIOUSLY, THANK YOU.

[ExcelIsFun]

You are welcome!!!

That is why I do this: becasue the duty of humans is to make the world a better place.

I also wish that there were fewer bad things that would happen in the world and this is the only way that i know to have an affect. Some people say "play it forward". If you can make one person smile, then may that person will give out a smile, etc...

[heroineo]

Ahaha thanks for making me smile with excell !!! :) Very cool tutorial x

[ExcelIsFun]

You are welcome! If you smile while you learn something new, the new thing learned is remembered more easily (sticks in your brain better!).

[renie1981]

@ExcelIsFun

YOU ARE AN EXCEL ANGEL. THIS IS SO UNBELIEVABLY HELPFUL! ESPECIALLY FOLLOWING YOU WITH YOUR WORKSHEETS. PEOPLE LIKE YOU GIVE ME HOPE IN THE HUMAN RACE! LOL. SERIOUSLY, THANK YOU.

[ExcelIsFun]

You are welcome!!!

That is why I do this: becasue the duty of humans is to make the world a better place.

I also wish that there were fewer bad things that would happen in the world and this is the only way that i know to have an affect. Some people say "play it forward". If you can make one person smile, then may that person will give out a smile, etc...

[ExcelIsFun]

You are welcome!!!

That is why I do this: becasue the duty of humans is to make the world a better place.

I also wish that there were fewer bad things that would happen in the world and this is the only way that i know to have an affect. Some people say "play it forward". If you can make one person smile, then may that person will give out a smile, etc...

[cumnkisme]

@ExcelIsFun

You have a good heart <3<3<3

[ExcelIsFun]

Excel is so much fun, it is easy to share!!

[thuynguyenable]

Dear ExcellsFun,

I have two data tables:-

1) 1 data table contains number of units sold

2) 2nd data table contains revenue of units sold.

Is a Pivottable able to combine different data from 2 separate tables into one PV? Or do we have to use one PV to count the number of units sold and create another PV to consolidate the revenue?

Thank you for your reply in advance.

[ExcelIsFun]

I am not sure, but check out if this Mr Excel video wouuld do the trick:

MrExcel's Learn Excel #928 - WIIW - Multiple Consolidation

[ExcelIsFun]

1) Start menu

2) Control Pannel

3) Regional and Language Options

4) Formats tab

5) Customize this format button

6) Change List separator to comma

[happy198508]

really like all your videos!! I have learnt a lot from you. thanks!!

[ExcelIsFun]

You are welcome!

[cindywuzh]

Thank you! You made the tutorial so interesting.

[ExcelIsFun]

I am glad that you liked it!

[dogxhot]

I thought vlookup ONLY works if the first cell reference is in column A ? was this ever the case ?

[ExcelIsFun]

Not that I have ever heard of!

[dogxhot]

Mike -if you go to Google and type in something like " vlookup only first column " you will see site after site saying that vlookup ONLY works in the first column

yet I look at your example you have violated this "rule" and it works fine. CONFUSED

[ExcelIsFun]

Dear dogxhot,

Column A does not necessarily equal First Column. So it seems that you are confusing these two:

1) Column A

2) First Column.

The rule is that VLOOKUP always looks up the value in the First Column, but that First Column can be in column A or Column B or any other column.

Does that help? Does that make sense, now?

--excelisfun

[dogxhot]

Mike -One final comment -

Around 7.21 the lookup value is G62 not the first column but it still works

[ExcelIsFun]

Yes, that is correct.

[ExcelIsFun]

Dear dchin8,

As long as you read the message box carefully before accepting, it should be fine. I never accept, I always go back and edit the formula because many times it does not suggest the correct formula.

--excelisfun

[xxxonelovexx]

i knew nothing about Excel n the team member would see me as a computer idiot.I recently buy a pc n now am learning from your videos.Thanks again.

you are the best man,

I will remember this favour in life.

[ExcelIsFun]

Dear xxxonelovexx,

I am glad that the videos help you! That is why I make them!

--excelisfun

[xxxonelovexx]

Wanna say ''thank you for ur videos"

you are the best man

[siamosh50]

Very helpful stuff, man. I bet you beat all the instruction books on Excel. Soon, you'll get much traffic due to the amazing job you did. I went to an interview on Thursday and they wanted me back on Monday, tomorrow, to chack my Excel knowledge. I didn't have any other source to prepare myself a bit, just your cool videos that I found on youtube. From now on, I'll be cheking it regularly if I have any problem on Excel,

Thanks again. Your fantastic acting is also great.

[ExcelIsFun]

Dear siamosh50,

If you have an interview, be sure to watch the Excel Basics Series (in my Playlists), because it covers what most interviewers will ask. Even if you are already smart with Excel (like you are: watching this big VLOOKUP formula), you will pick up a few good things in that series.

Let me know how the Excel Test goes!

If they ask something that you did not know, let me know and I will make video!

--excelisfun

[siamosh50]

Dear ExcellsFun,

I attended the second round interview today and many many thanks to your cool videos, I did a great job in the Excel Test Knowledge, I got 90% result. ...

Should I not have prepared myself by reviewing your videos, I could have not answered at least half of 75% of the questions.

Again my hats off to your job and World Wide Web....

Siamak

[ExcelIsFun]

Dear siamosh50,

Congratulations!!!

If you can tell me what that 10% you missed was about, maybe I can make a video.

--excelsifun

[ExcelIsFun]

Dear siamosh50,

Yes, if you know others that want to learn Excel, let them know that Excel Is Fun.

--excelisfun

[xxxonelovexx]

Dear Excelfun,

i wanna say a ''big Thank you to u" for all ur videos,Its really helpfull......

i knew nothing about excel n the team members would see me as a computer idiot at work....i recently buy a pc n now am learning from your videos.

I will remember you through my careers...It is here where am starting it.

Thanks you again.

[shiryu008]

Man, Michael Phelps is like a child compeared to you mike. Hey!! Give excells Fun a gold medail for each video, Yes 329 GOLD MEDAILS FOR YOU!

[ExcelIsFun]

Dear shiryu008,

How about a gold medal for you: most videos watched in a day!

--ExcelIsFun

[ExcelIsFun]

Dear zolo538,

I am glad that they are helpful!!!! That is why I make them!

--ExcelIsFun

[periwink]

Doh! I said 4 stars, but I always give you 5 !!! I was too busy looking at numbers to realize it LOL. Typo.

[ExcelIsFun]

Dear periwink,

Rate 'em how you see 'um!!

--ExcelIsFun

[periwink]

Rate em' how I see them?!!??!! I SEE THEM ALL AS LITTLE GEMS! very valuable information here. Anybody in the admin field, knows, that Excel is one of the most commonly used programs. I'm a wiz at typing, but without knowledge of Excel, it won't get me too far. I'm not going to stop at taking a class, i'm going to continue with the books you recommended...with the constant reinforcement, I will slowly get comfortable with Excel, so that I don't get nervous :P. (thanks also4 UR help and sound FX)

[ExcelIsFun]

Dear periwink,

Yes, it's true about Excel - most jobs require it. Sometimes I am amazed with people in my business classes (Stats, Finanace, Accounting, Math) that say they are mad because I am teaching using Excel. I tell them that they will not be doing Stats/Fin/Acc in their job with paper and a hand-held calculator. Some of them drop my classes & say they won't need Excel. But they will get a shock when they get a job....more

[ExcelIsFun]

Dear periwink,

Constant reinforcement (practice, practice...) is the method that is most effective for learning anything! That is how I learned Excel: every day I learn a few new things, & I force myself not to shrink away from the hard tasks, then after a while the momentum is on your side & you are flying!!

Thanks for being so smart and hard working, periwink!

Luck for us (YouTube Excel Team), we have lots of other YouTubers that are just as smart and hard working!!

--ExcelIsFun

[periwink]

5 stars! Thank you for showing all of the vids on VLOOKUP. It's what I need. thanks

[ExcelIsFun]

Dear periwink,

Now you can post on Craig's List for Accounting jobs and just say: "I can do VLOOKUP in my sleep"!! (Actually, that famous quote is from Bill "MrExcel" Jelen).

--ExcelIsFun

[periwink]

Ohhh! I wish I could do VLOOKUPS in my sleep :P. Or do i? LOL

I'm not that confident in Excel, not at all. As a matter of fact, I'd be up the creek without your helpful videos! Or I would have bought a few programs that would have taken a lot of my time...(not kidding! yikes :o) - I'm more of an ACCESS person. I liked it a lot more and for some ppl, they say it's harder ? Numbers intimidate me. (prolly cuz i'm mathematically challenged)

[ExcelIsFun]

Dear periwink,

Soon, you will be able to do VLOOKUP in your sleep! The only reason that people say Access is harder is because many fewer people know how to do even basics with Access. If you are an Access person and a newly budding Excel person, then that means you are doubly smart!

--ExcelIsFun