Microsoft Excel VLOOKUP Tutorial

[vcodio]

Great Vid... I am having an issue where only part of the data populates. I.E I have two files one with 5000 records and an other with 200 records. I need to match some of the fields, however, only about 125 are updating. I am certain all 200 records should be available. I have converted the unique indicator by copy/multiply by 1..... what am I missing? Thank you!

[drew202k]

great video

[iibi1367]

Great video. I also found this tutorial and article on Vlookup and pivot table very helpful

tutoraccounts.blogspot.com/201­­1/10/microsoft-excel-2007-tip­s­-and-tricks.html

[brettlee2010]

Such a polite way to teach. May Allah bless you & show you the right path :)

[MsNJohnson]

Excellent video!!!

[Anjulovesindia]

Thanks for this tutorial,it is so clear.Good job Richard.

[Troop2496710]

Thanks for this. Tutorial. Sounds like my lecturer at uni. Clear and coincise

[Frankthetank23]

press f4 once after highlighting the area you want to put dollar signs.

[Jetrothull]

@Frankthetank23

thank you, your tip is helpful.

[jaketrogers]

Poor Bill

[nhgh0208]

@jaketrogers Hey I need a little bit of advice on vlookup but am fairly green to the internet highway. Are you the person giving the tutorial?. If so can I ask you for some advice? If not can you tell me how to get a response for my questions? I can't seem to get past other peoples blogs, call me a dumbass but any advice would be good.

[599CD]

@nhgh0208 I can't promise a speedy reply, but I'll do my best. I get a TON of email, so I don't always get the chance to help people directly here on YouTube. But, if you follow the link in the INFO sections above, that will take you to my web site where you can also submit your questions to me there.

[sweetladybad]

thank you for this vedio has helped me overcome my problem

[thelalitmaheshwari]

thanks freind........a big thanks

[Tweekki]

This toot rocks! I've spent hours trying to figure out vlookup and in six minutes this toot taught me everything i need to know for the moment! good job!

[samson771000]

great thank you

[samson771000]

great thankyou

[MrHappy1753]

THANKS for your awesome video! Really helps!

[MrMOONHEAD2]

Thank you!

[AWatProduction]

I have a problem...

I write =VLOOKUP(B2

-but when im going to right a "," and going to select the table-array is says that there is an error? Can anybody help me why it says this?

[faha1ali]

great informative

[chungweiteng]

this is so helpful, thank you:)

[sharma1103]

Amazing tutorial.. Others made it so confusing... This guy is good... Thanks dude...

[TheClanWarsChanal]

this video is EXCELlent

[walkdpath]

Thanks a ton...plz continue posting such sample lesson..it acts as a confidence booster for beginners to learn further.

[RebekahsTube]

I watched this viThis helped me so much. I read my coputer book over and over and used my ebook and I just could not get it to click in my head untill deo. Thank you !!!!

[thisisouraccount]

THIS A REALLY GREAT VIDEO..THANKS FOR UPLOADING

[Okay98]

Wow, this has to be the best vlookup tutorial I've seen around, others can be quite confusing because they don't explain it properly, thanks a lot!

[599CD]

@Okay98 Thank you!

[Okay98]

@599CD No worries, I was having a lot of problems sorting my excel stuff out till I watched this, thanks again!

[sweetladybad]

thank you f

[SuperBlaze999]

hello thanks for the vid but in v look ups when ppl put $ beteween the numbers what does that mean???

[599CD]

@SuperBlaze999 Yep, like andre said, the $ signs make an ABSOLUTE REFERENCE. This way you can AutoFill down a column and the cells won't change. Say, for example, you've got a static value (like a sales tax rate) in cell A1. If your order amount is in B1, you can say:

=B1*$A$1

Now if you AutoFill down the column, The B1 will change to C1, D1, etc. but the $A$1 will ALWAYS point to A1.

[599CD]

@SuperBlaze999 That's called an Absolute Reference. I have another tutorial that explains that.

[ieysfreak]

thank you for the tutorial. i easily understood it.

[bluespirtsam]

The tone of your voice is rather plane, great vid tho :)

[andre50203]

u can put the $ to absolute. so u can drag down without any problem

ex :=vlookup(B3,$A$9:$B$13,2)

thankss

[sebargentino]

i have a home sheet 1 and sheet 2 and sheet3

now i sheet 1 i spent 50 dolars so it will appear in sheet 2.

now i try to put new columns in 1, and i put the # but nothing appear in sheet 2.

how can i make it work?

[queenofthehop]

THANK YOU SO MUCH!!!! this helped greatly. i couldn't understand what that column number was but this is great! thank you for doing this! =)

[dineshtakyar]

Excellent!

[guptaprakhar]

Thank u soooo very much!!!! I was stuck with vlookup fr 2 hrs.. This vid was a grt rescue!!

[dangerdown]

very helpful video, thanks. lots of mouth noise on the audio, though.

[mazr2006]

thaaaaaaaanks

[phuong0302]

thanks

[squeak9121]

Thanx, this vid was very useful

[scrapdough]

you're video is by far the best. question please, on the lookup table, you've had each corresponding value for each entry (i.e 65=d, )

is it possible that instead of placing a value,(65) if u left it blank (as in no entry at all), it would still give you a score of D?

many thanks

[599CD]

In order to get the value, VLOOKUP has to have something to return... so you'd need to have a "D" or some other value there.

[dirtbikerpro]

you dont have to use vlookup to get values from another page of your workbook though

you can just click on the certain tab you want and the value while inputing the code

[anilmutlu]

you have to sort your source datas by what's you look up

[lubenitza2004]

It gives me an error. I do=Vlookpup(and everything but no good). I don' t have the function right? How do I add it cuz I do not know. Thanks

[kongo30]

which excel version are you using? i use norwegean and VLOOKUP is FINN.RAD.

Got a prob though, i do not seem to go beyond '' =VLOOKUP(B3,.....)

Im getting an error when i try to highlight the lookup table contents as in ''A9:B13''...

( (

[xasiyax]

Thanks u save me from failingg my I.C.T..:D

[walau123c]

can vlookup hlookup work for 2 different excel files ?

like file 1 vlookup work with file 2. both of them is in excel format.

[599CD]

Yes, the easiest way to do that is to select your lookup table, COPY, then switch over to the other sheet, paste a LINK to that lookup table on a different sheet, then use that as the range for your VLOOKUP function.

[msa5649]

How do I expand the vlookup for the entire column.

[599CD]

I don't understand your question. Can you elaborate please?

[DeannaLC]

I have been working on this for 3 hours, after going to You Tube...I watched several clip videos, yours was the easiest to read and follow. Bottom line, I now know how to add the vlookup feature in my document. THANK YOU!!!!

[lukascagewilson]

thanks so much, i know excel pretty well but was applying for a job that needed to know this function. i think i'll go ahead and apply.

[ugotitbad5]

thank u very much!

[flareman666]

First of all, I wasn't complaining. I was just seeking your advise on what I could have possibly done wrong. Anyway, I understand the problem now. The table array scores needs to be arranged in ascending order from the lowest on top to the highest at the bottom. This wasn't explicitly mentioned though. But thanks for this lesson. I found it useful.

[flareman666]

Hi, i tried practicing what the video has shown. But it doesn't seem to be able to interpret the score range whether it is higher or lower than whats in the 1st column and return the grade.

For example, in your video, a score of 90 or higher gives you an A grade. But when I do it, I put a score of 93, but it returns as #N/A. Unless the score i have is exactly 93. What am i doing wrong? Appreciate your advise.

[muttleydog]

Fantastic! It's so easy! I have using lots of nested IF statements and getting completely fed up as it can only use 9 at a time. thank you for making it look so simple.

[imayjustsay]

Not clear, could have used a Nested IF statement.

Why use a VLOOKUP?

[599CD]

Functions have a 255 (I believe) character limit. What if you have 20 conditions? That's a lot of nested IFs.

[naveenprasadmonu]

EXCELENT