Microsoft Excel VLOOKUP Tutorial
April 14, 2010 | 
Author 
Learn how to look up values in Microsoft Excel using the VLOOKUP function
Incoming search terms:
Posted in microsoft excel | 
Tags: excel, Excel Function, Excel Tutorial, Excel Vlookup, microsoft, microsoft excel, Microsoft Tutorial, Tutorial, VLOOKUP, Vlookup Function
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?
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! =)
Excellent!
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”…
( (
Thank u soooo very much!!!! I was stuck with vlookup fr 2 hrs.. This vid was a grt rescue!!
very helpful video, thanks. lots of mouth noise on the audio, though.
thaaaaaaaanks
thanks
Thanx, this vid was very useful
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.
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
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
you have to sort your source datas by what’s you look up
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
Thanks u save me from failingg my I.C.T..:D
I don’t understand your question. Can you elaborate please?
Functions have a 255 (I believe) character limit. What if you have 20 conditions? That’s a lot of nested IFs.
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.
Software New: Microsoft Excel VLOOKUP Function Tutorial Pa 3 http://bit.ly/b6UHkd
can vlookup hlookup work for 2 different excel files ?
like file 1 vlookup work with file 2. both of them is in excel format.
How do I expand the vlookup for the entire column.
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!!!!
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.
thank u very much!
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.
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.
Microsoft Excel VLOOKUP Tutorial: Learn how to look up values in Microsoft Excel using the VLOOKUP function
Video R… http://cli.gs/gQj1H
Microsoft Excel VLOOKUP Function Tutorial Pa 1 | LaNClip http://ping.fm/C0y3l
Microsoft Excel VLOOKUP Function Tutorial Pa 2 | LaNClip http://ping.fm/h7ILP
Microsoft Excel VLOOKUP Function Tutorial Pa 1 http://goo.gl/fb/bnvCR
HelpingNet: : Microsoft Excel VLOOKUP Function Tutorial Pa 2 http://unfake.it/SdWp