If you use Excel much at your job, sooner or later, you’re bound to need to look up values in a table. One of the most useful functions in Excel, called vlookup, does exactly that. The “V” in vlookup stands for “vertical” and “lookup” is pretty self explanatory. This function allows you to look up values in a table that are listed in column format (how most tables are laid out), given another value (let’s call this the “key”). Excel also has a sister function called hlookup (h = horizontal) that can be used to look up values in rows.
Sadly, as most companies seem to rely on Excel as a poor-man’s database of sorts (a totally unscalable solution and prone to errors with every revision, but don’t get me started), once you know vlookup, it’s likely to become one of your most often used Excel functions.
So, let’s get started with a very simple example of what vlookup is all about. Suppose you had the following table:
Given a list of names in another part of the table (in this case, column H), you want to figure out what kind of animal it is:
Vlookup’s format looks like the following:
Let’s look at each of these parts a bit closer.
The first thing that goes into the vlookup function is the thing you know (or are given) and that will be used to lookup other values. In this case, you have the names of the animals, so these are the things we know. In our example, they reside in column H, from cells H2 through H5. If we wanted to put the type of animal next to the name of the animal in column I (so I2 would correspond to the name of the animal in H2), we would insert the vlookup function there:
and put H2 as the first thing in our vlookup function:
Next, we need to know the location of the table where our values reside. These happen to be from cells A1 through B5 in this example, which we would highlight with our mouse to insert into the vlookup function. It’s very important that you include all the cells in the table.
Highlight the table with your mouse:
At the same time, the vlookup function automatically puts in the cells you’ve highlighted:
Next, we need the column number where the values are located. Always start with the first column (column A in this case) as #1 and count out to the right. In this example, the type of animal listed is in column 2, so that’s what we would need to insert in the vlookup function. Note that to use vlookup, your keys always have to be to the left of your values. (We’ll cover more of this in part II of the tutorial at a later date.)
Finally, the last attribute that vlookup takes is either “true” or “false”. I happen to always use “false”, and what this does is force vlookup to return the first exact value it finds. If that value isn’t found, then vlookup conks out and returns “#N/A”. Though we won’t use it in this example, if you select “true”, then rather than always looking for the exact value, vlookup will return the exact value if it exists, or the closest one to it that doesn’t exceed the key. (If you use “true”, you will need to sort your data in ascending order before using vlookup.)
Still with me? Again, this is what we would actually put in cells I2 if the names of the animals we have are located in cells H2 through H5:
Once we close off the parenthesis and hit “Enter”, vlookup automatically calculates:
And so on. We would continue down each cell in column I that we needed. One thing to note is to make sure that the location of your keys and values is always selected correctly. Oftentimes, as you copy-and-paste formulas all around Excel, the location of the data will also move around relative to the cell. The easiest way to prevent this is to “lock” the range of the location; in this case, we would do so by using “$A$1:$B$5″ instead of “A1:B5″. This way, as we move down column I, say, to cell I2, A1:B5 doesn’t become A2:B6 but stays with the original range of data. This way, we can just copy what’s in cell I2 down the rest of the cells (from I3 through I5):
Finally, here’s our result, after making the “$” changes and copying and pasting the formula down the rest of the column:
This has been a really simple example of vlookup, and I’ll cover a bit more in part II with another example, still simple, but with slightly more data.
Although in practice, vlookup is usually used between Excel sheets and workbooks, once you understand this example (which has been done within a single sheet), using vlookup outside the same sheet shouldn’t be much harder. Look for part II soon!
Popularity: 31% [?]
***************************************************
Get Help With Your Excel Spreadsheet for $39
Take A Look Into Our New Excel eBook.. on sale for $9.95
***************************************************
JLP’s Weekly Roundup (Week of November 12, 2007)—? AllFinancialMatters
[...] Last but not least, Ricemutt has a nice tutorial on how to use the VLOOKUP function in Excel. – If you don’t know what I’m talking about, you NEED to read the tutorial as it is a really cool tool. Bookmark to: [link] [...]
Ignore Finance Experts, VLOOKUP, Debt Disease, and Making Your Debt Known » Blogging Away Debt
[...] Ricemutt wrote a great tutorial on how to use the VLOOKUP function in Excel. If you use Excel, this is a super-handy tool! [...]
Muhammad
very useful, God bless you
RAMU
iT IS VERY USEFUL FOR ME
Chirag
Hey Dude! Its a great one…..
I m pleased with your work…
Please published second tutorial please…
for that thx in Advance.
kazi
it is very great to follow just give us more information about v lookup
How to use VLOOKUP in Excel (part II) - some tips and advanced Excel tricks | Experiments in Finance
[...] Business Promotional Item fasb 141 valuation credit repair var site=”sm7ricemutt” « How to use VLOOKUP in Excel – a simple tutorial (part I) [...]
Ghazala
It was fantastic. I really learnt from it. I had done excel long time back in the year 1997-98 & I didnt know what is V-LOOK UP & I was looking out for the job, they ask me do you know pivot, h/v look up; so now I can answer them yes. Thanx a lot. If u can please also show me H-LOOK UP & send the information on my email address. Waiting eagerly for your reply.
Martin
Great! Very simple and usefull explanation
http://www.experiglot.com/?comments_popup=599
[...] writing a post about this entry http://www.experiglot.com/?comments_popup=599 Stay [...]
Andy
I wanted to know why and when we would use Vlookup, rather than simply how to do it, so that I could preparemyself for a job interview which involved a test on Excel, and this explanation does all of that. I have found countless sites that explain how to do it, but unless you know when it is going to be useful or beneficial to use then knowing how to do it is useless in itself. So thanks. . . .
Aditi Jaiswal
this is gr8!!, keep it up,
waiting for PART-II
meme
très didactique! bravo
manas srivastava
although it is very much sufficient to make one understand the concept but could have been elaborated more on so that one could be aquainted with with finest details of Vlookup
Sumeet Chandra
Kudos to you for making vlookup look so simple !! ..gr8 job
Tim
Is there a very simple way to use VLOOKUP to compare one single column alpha-numeric list against another and have the results appear in a third list?
For example: I want the third list to return a column of the exact match between the first and second list and return “False” or “NA” for those items that are found the first list but not found in the second.
Huchein
Its a really great tutorial which explains the basic application of Vlookup in a very simple way.
Thanks
Susan Lew
Hi,
I have try this format that was shown on this website:
http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a-simple-tutorial-part-i/
but my computer did not calculate the answer as what you have indicator for example:
Fido Dog
Mikey Mouse
Instead it show #N/A
how should I go about it.
I am learning Vlookup, through website
Kindly please advise
Thank you
Kevin
Thanks a ton. I just used this on a massive spreadsheet. Worked Great!
vinod chincholkar
excellent info about vlook up given on this site.. hat’s off, gr8
Balvant
Simple and excellent explanation.
Thanks.
Sahil
THe explaination of vlook provided by you is so good, simple and easy to understand that it took no time for me to understand what vlook exactly is. it’s so knowledgefull for me.
Thanks
Nena
You guys are GREAT this is the first and so far the ONLY site that really describes the HOW to for the VLOOKUP, thank you for the Great explanation in PLAIN English.
Akhilesh
It was very helpful for me thanks lot and my all wishes 4 y
FARHAD
Iam not able to make the Vlookup formula its giving me command error
Jayc
This tutorial is clear and concise. Safe for that! I think you should also write a tutorial about pivot tables as well.
£ucky
its amazing ….
tips are really very helpful…!!!!!!!
Raaz
its awe some.
its really helpful
thanx………
Adnan
Example is very good atleast for me, had no idea to how to apply this, but i need some more expample like this
prasad
i dont know abt vlookup but after viewing ur example i got it
ur explanation is awesome………..
Anil Pillai
Thank you, for your valueable example to start up and for finding a valueable reports in no time.
Warm Regards
Anil
Palani Selvaraj
It is one of the useful tools, Thanks to the Publisher.
abdel
Great stuff. Thanks
Life is simple. keep it simple.
niru
Excellent
chowdhary
very very useful for any person who has the zeal to learn, but have no money.
I really appreciate you service…………
omar
hey bro.. great work.. thanks for the simplified yet understandable tutorial.. much better than what my prof at uni taught.. thanks.. :)
ahmet
thank u man, May Allah bless you
from istanbul city
Sheikh Sarwar
I felt comfortable with your tutorial.
Syed Zahid Hussain Shah
Dear Sir,
I have a question that if i found #N/A in my sheet which is making difficulties to calculate net amount, is there any option to replace automatically #N/A with 0. I don’t want to change any formula becouse sheets are a lot and i have many options to change this value with 0 by formula but at this stage i need to know option in excel.
hariom
Please send me 1 copy for how to use VLOOKUP
Bhuvan joshi
Spot on!!! Keep up the good work!! Waiting for more …
Regards!!
Bhuvan
SELIM
It’s good.Really helpful.
Migs
Sorry but I can’t get it to work for me.
My answer(s) lies in a table of two columns, one of which has the identical number which equates to the name of the dog in example above. I then need to go to the table of two columns, match the number in my original cell, in the first of those columns, and then have it reflect the answer beside it in the next column and place it in my original cell in the equation???!!! For the life of me I can’t make it work. If you can help I would appreciate it very much!
Vishu
Thanks tutorial
Today I learn How to create Vlookup
Formula
Bryn
I have saved your sight to my favorites.
You explain in such an easy way. Good bless you.
ken
It’s really helpful for me to go thru this tutorial, thanks!
time for question:
is it possible for me to put the “lookup table” on a different worksheet, then using other worksheets to refer data from ‘that’ sheet of the table but calculate on the other worksheets??
sorry if i didn’t word it properly, hope you understand & have time to reply me, thanks!
BHARATH
i am getting error: #NAME?
so pls send me soloution ..
replay me soon…
MANDEEP
Thanks it is a wonderful experience
jah
this site is very helpful. i understand vlookup by reading your material. thanks
hazel ann
wowww…it’s great to know this function. So helpful….tnx a lot!!
PRAGAT
it ‘s a very good system.thank’s
CCNA Training_Karrox
My work demands the use of Vlookup function and now I can use it easily. Thanks for simplified information.
LoneWolf
great work buddy.. cheers :)
Rahab
Fantastic, easy to understand.
Nia
More important than useful, I could follow through what you were saying! Thank you. NOW it becomes useful. :)
I didn’t really understand the $ bit though.
Dawood Mamedoff
Hi, thanks for explanation! For simpler illustration of how vlookup works I’d also recommend the following video tutorial:
http://www.myhowtoos.com/en/excel-howtoos/84-how-to-match-values-in-excel-using-vlookup
vishvajeet sisodia
hi it’s very nice formula for me
and now iam a computer teacher and
before i don’t now how to create vlookup but now i learn vlookup
i will waiting for next editin
thaxs
Jane
This is so much more easier to learn than looking up in Microsoft web site. Really appreciate the tutorial.
Venod Raveendran
Thank you very much.
Really save
me half hour
Marcia Mayhew
Finally the mystery made plain!!!
Thank you
Look forward to part II
saurabh
very useful ! Thank You
Ling
Easy to learn instructions. Thanks!
Jane
Finally, instructions I can understand!
dan
Very helpful. Thanks.
Comment:
“$A$1:$B$1? instead of “A1:B5?
should read
“$A$1:$B$5? instead of “A1:B5?.
stan
simple but effective thanks God bless you
Rahul malpani
dear sit,
i saw the vlookup practicaly formula but didn’t understand completely, it’s very useful so want to learn & use it more, so pls available the practical vlookup with practical exa.with detailed instruction, pls.
regards
malpani.
Seetu
very nice & simple
Leonard
You have a mistake in your text. Near the end when “locking” the lookup table, you state: The easiest way to prevent this is to “lock” the range of the location; in this case, we would do so by using “$A$1:$B$1? instead of “A1:B5?
What you meant to say is “$A$1:$B$5″ – you had a 1 instead of a 5 after the B. In your screenshot, you had it correct.
Love the tutorial – thanks a lot!!
Leslie
Thanks for the catch and correction :)
S Ganesh
This is excellent Way of Teaching
God Bless You
Ganesh
S Ganesh
It is Very nice Training
God bless You
Ganesh
umuriza odeth
this expalanation has been so simple and good. keep it up, may God bless you
S Ganesh
It is very nice to learn in the easy way
can u give notes on excel macro
it will be useful for me
Wendy
Thank you so much for your simplistic approach! God loves you :)
vikas
its good for practice thanks it excellent
hmmm
when you say highlight table with your mouse, do you mean with mikey?
DIXIA
very nice & simple
thnx
punki
Bless you indeed:)
You made it really easy to understand, thank you for educating the masses for Free!!!
Best wishes:)
P
james
very very very much thanks for this example
Dee
Thank you. Life saver!!.. Done the Vlook up in no time
vikas
mind blowing, god bless you
Suresh Babu
thank you very much, it is very good for practice, once again thank you very much for sharing your thought with us
Muhammad Nasim
Bundle of thanks it is very usefull information.
ANUP
this is very important for me it is really very useful thank u buddy……….
Thamer
Very simple and clear. Thank you, it helps me finishing my project.
Karthik Manoharan
I have used, Its really amzing that i have learned it very quickly and easily, Thanks a lot… Great work……
RAMKESH
wow! how nice and eassy,
thanks for guidline.
simon
I had been able to do it without understanding, this means I now understand how I did it, thanks
Akhilesh
Finally the mystery made plain!!!
Thank you
Look forward to part II
Priya
This is nice
mohd raqib
Respected Dear
Thank You very much
I was searching this from very long time.
so thanks again
bay bay
pooja sharma
thanks a lot dear ………….
Praveen Gupta
Dear Sir, its a easy and step by step way to learn how to use VLOOKUP…
keep it up
thanks!
Kochu
Hey Thanks for this. Really simple and well done!!
Have a job interview and this is one of the requirements. Thanks Leslie!!
Ajit kulkarni
Its great,
Thanks
BHUPENDER
Very good example very simple……..
Jatin Seth
Thanks alot, really helpful, now i can atleast understand basics V look up.
bill
Good job. I finally understand the concept. Microsoft help sucks, doesn’t it?
devender shekhar
i am using ms office 2007. i want to use vlookup function……. can u pls guide how to describe a sheet of another work book from where data is to be picked? i am able to use vlookup in same workbook with different sheets but not with sheet of a different workbook, pls guide…
Peter Overnell
Excellent tutorial, thanks a million. Now to deal with part II. Do you have any guidance regarding the protocol for Excel formula? I’m no mathematician and find the concept of formula construction rather daunting.
Sachidanand
Wonderful example!
Now i can use this formulla.
Sachidanand
Ujjwal
Helped us a lot
Mohammad Ameen
i waz really confused about vlookup but now i m feeling relaxation because my boss told me that yesterday this work will be complete & utilize vlookup but i didnt know that wht is vlookup, now my work is completed from the help of vlookup marvellous ya.. thxX
Kathy
Thank you! This was a huge help for me! I have an interview tomorrow and VLookup is listed as a required skill. Your tutorial was great and gave my memory the needed kick to help me re-grasp training I had while back!
Tom
Thanks for the great detail instructions this has help me better understand the process of vlookup function – I would like see more tutorials on this subject using if,and or else statements.
Thanks again and peace to all
Neta
This is fantastic and has been a great help with the spreadsheets I currently use on a daily basis.
I need help with finding duplicates on worksheets from reports I run monthly.
I’ve tried a dummy run on past work sheets but I dont seem to be getting anywhere (argh!).
Help please?
Elissa
Thank you for this resource! It was much easier to follow and described each step more in-depth than most other LOOKUP how-tos.
Partha
i had gone through ur VLOOKUP part one which is excellent than any book as well as Microsoft office help desk. I had gone through many books which made me sometimes worng evaluation of VLOOKUP. bUT THANKS A LOT . I want more excel function in simplified examples
than k u thank u
Manikandan
In excel i searched in the help option but i cant understand the forumula. But your are giving very easy method it’s very useful for me. Thanks a lot…….
amol
thank you very much, now i am very much clear about this.
venu
thanks a lot…where is vlookup part II?
Partho
This is very good article and can help a lot to learn such titles in less time. Thank you.
Partho
helpfull.
anurag
its was awesome i undrerstand better here.
Jai
Wow! Great job! You are very smart person!
Thanks for the info. Do you have a website where I can ask further tutorial questions?
I hope God always bless you for sharing your knowledge.
Vineet
It was awesome going through the document
Hamisi Malipula
Simple and very useful. Be blessed.
Mohsin
Thank you.
It was very helpful.
Vinod
Now I understood the use of vlookup.. !!!!! thanks.. :-)
Dibyendu Roy
Thank you so much for to me easy to way learn Vlookup.
Thank you very very much.
sathishs
Thank you so much for you.. uve explained this so easily
CHETAN G
very use full but show in details
rajan
i want to know about lookup, v&Hlookuop
plese describe and send msg on my E mail plese it’s urgent
PAMMY
Thanks a lot!
It really helpful for me…………..
Sonali
This is awesome tool to learn… It helped me a lot in completing one of my project.
Sibiya Kudzanai
to avoid the #N/A message that some are getting above it is a matter of making the range absolute.
solution: after selecting the lookup range just and JUST hit F4 and continue. it will work
Subhas kumar
Yes, it is very useful function………….
David Wilkinson
I printed this out to read off-line. It produced 55 pages. What a waste of paper..
HABIB AHMAD MAYO
It is easier to understand. Explained very well. Thanks a lot.
Sohaibullah
very nice work, I think every one can learn from this example. You are absolutely great.
Muhammad Mahbubur Rahman
You explained it very nicely.
SWARAMAN
Thanks for the example. Was really an important thing in Excel
ravikiran
thanks
Love Ravi
Good job done dear….
C.Ramkumar
Its Very useful guide
Sushma
Its really very helpful, thanks a lot.
otis benton
where is the second tutorial on the Vlookup you promised. this is the one you use two spreadsheets to do this skill.
Manoj Kumar Singh
Its nice
kiran
greattttt……………..
puneeth
This was a super guide to vlookup. I recommend an award for this. Nice work
ASHOK KUMAR MALIA
this is really amazing, I am surprized, real mein abhi tak suna tha vlookup command very tough. But, this is magic, haqueeqat mein koi cheez kathin nahin samjhane aur samjhne ka farq hai, thanx for this !!
Masha
It was very helpful for me thanks lot…
Easily understood the the concept in very less time..
Thanks for the great article.
harkesh
Its a very good article.
Easily understood the the concept in very less time..
Thanks for the great article.
harkesh
This was a super guide to vlookup. I recommend an award for this. Nice work
Trilok
Its very useful the way of explain is outstanding thank you so much
G. Sivasubramanian
Thanks!
Please send Vlookup formula with Example
kirankumar
very interesting concept, please explain me in real time where we can use this concept.
shyam
I am very thankful and greatful to you
thanking you….
Chris
Thanks, a very useful tutorial
DARSHAN
Product 5 10 15 20
orange 5.3 4.8 4.2 3.5
apple 1.43 1.4 1.25 1.1
bananas 1.5 1.45 1.33 1.15
pineapples 5.5 5.4 5.2 5
waterelonmes 7.89 6.5 6.02 5.8
code qty Result
banans 5 1.15
orange 18 1.45
APPLE 5 1.1
PINEAPPLE 3 1.15
Nitin Parab
I have one doubt.when there are two different value under a single same name then how can work this formula
Venu
i need to compare data and to print the values matches with primary key in a single column
Ex: register No. 56 order No is 234 in first column, 2345 in second column and 123 in third column.
this need to print in sigle column i.e 234,2345,123 if condition matchs with Register No.56
KSSREDDY
I’am siva
really superb……thank u so much…it was really easy for to catch up well
KSSREDDY
Thank you for this resource! It was much easier to follow and described each step more in-depth than most other LOOKUP how-tos.
MEENAKSHI NARULA
EXCELLENT ! I EXPLORED MANY TIMES ON NET FOR HOURS BUT COULD NOT UNDERSTOOD. THIS SITE IS VERY BENEFICIAL FOR ME. BIG…THANKS
Tanvi Rawal
It is very useful for me, need to learn these types of examples more .
Thank you in advance.
Udeemax
Very useful…Elaborate and simple.
krishan sharma
it is very useful
Jatin Kalra
Please all the detais send to my email’s id actually i have not clear my concept of Vlookup, Rlookup.
So please send it now, its urgent.
basavaraj
Thanks a lot
Ken Kugz
what a fantastic elaboration!
Gurdip
Its really very nice, Explain the things in a very lucid manner. Kindly keep it up.
pks
very simple and useful explaination.
Thanks.
manpreet
this is so simple way of learn v look up .thanks fr this
Sukanta Kumar Roy
Its very useful.Atlast came to know how it works..Thanks a lot.
mayuri
how operate vlookup…… plz sand me vlook up formulas
Amit
Thanks a lot dear
Lokesh
It was quite helpfull to understand the basics…
Manoj
Great.Now somewhat i came to know abt the power of Vlookup function
thanks
Alex
Excelent example, thank you!
PRADHUMN SHARMA
GOOD LEARNING LESSON
THANKS
Tammy
Thanks, excellent, really appreciate you going to the trouble to make VLOOKUP so simple for folk like me.
satendra tiwari
dear sir/mam ,
plz help me vllokup process,
i am waiting plz,
regards
satendra
denise jones
this is great!
Rochelle Pereira
Best Vlookup explaination. I checked out atleast 4-5 other websites to understand Vlookup albeit unsuccessfully when I saw this site just as I was ready to give up and the explanation was so simple that I got it at first try.
Amazing simplicity in explaining the concept and how it works.
RANJIT KUMAR MAURYA
It is very good. I have learnd from this.
Thanks.
GANESH
Thank you so much yar.
Its a very good example to understand.
its simply superb. It will be greatful if u provide the lookup’s in different scenarios
surajit
its amazing experience after getting such useful help………thanks
vijay panchal
excelent
Joel L. Meliyo
Very nice piece of work, detailed to the dot, simple to follow.
Many thanks
Soumya Kanta Sahoo
its awesome dude…….really very helpful for me…to grasp hope u teach us few more of them….
asha
It was very easy and simple excample to understand . its very useful .
Mustafa
Great work dear
Rajesh Maurya
Plz send me vlookup formula detail Its urgent
Thanks!!
Queen
I had tried several times to understand vlookups but never really did. Many thanks for the simple and clear examples.
prakash
Hi mate,
u made life so easy in Vlook up,believe me i have been thinking this is very difficult task since many year(though not tried),now after your simple tutorial,i got the concept.
kudos to you.
MICHAEL MURRAY
VERY SIMPLE TO FOLLOW, please send more simple examples.
thank u
Saurabh
thanks.. it is very useful.
aditya
Very simple and knowledgeble!!!!!!!!!!!!!!!
M Dumbuya
I have a problem with using Vlookup. I am trying to lookup document numbers in a group of data arrange in column. The data I want to lookup are in the left hand corner and the table where I want to lookup the data are in the right hand corner. After inserting the formular vlookup, it gives me some of the documents I am looking for but the remaining once, it say not available while they are there. Please advice me on how I can solve this issue. Kind regards Musa
Ben
You are a hero. You saved me about 6 weeks of work.
Muslima Ruhumally
Thanx to this simple example of vlookup, am able to prepare mysef better for my interview which requires skill on this function of excel.
Bakurudeen
thanks
Umesh
Good one!
Sailesh Pokhara
Thank you very much for explaining it in simple way.
It took less time to understand it.
Great job.
Youssef
Really this is a great simple method… thank you soo much
Aarya
It was really helpful to me , thanks a lot
KSHETRAPAL SINGH
thanks for you easy vlookup ka tarika hai maza aa gaya thans god bless you.
Tarun
awasome! example. Thanks and I get it
Siddharth
Quite nicely explained :)
sarmad shaikh
bro! it’s really simple and comprehensive to read even you go through it I was practising at the same time.thanks
Murali
Thanks. It was very helpful fro me to understand the concept of vlookup
titus
Good job, more examples please.
janardan
thank you giving knowledge.
pardon madhanzi
this was helpful, i have been helped indeed!
for beginners its good information, i tell you.
Ritz
How to use V lookup from right to left?
MANISH AGARWAL
EXCELLENT BROTHER…. U ARE TOO GOOD…
Basavaraj.Hukkeri
Idid’t know this formula this use for me thank you
Basavaraj.Hukkeri
I didn’t know this formula this use for me thank you
theju
You are a grate teacher…..thanks a lot..
Patrick
That was excellent it has realy made my work easier.
Mohit
Awesome explanation. too much helpful. Thanks a lot for you guys for running such web.
narendra marrapu
It is really awesome explaination.
Thank you very much for this. I may learnt alot from this.
naveenkumar
its good know the basic excel
vishwajeet
thank you very much….
it seems complicated on excel but you made it simple.
thanks man !
Damodar
This formula is excellent. This saves times & energy. Thanks
hari
neat, simple explanation. thanks a lot
MARCHILO
VERY VERY VERY USEFULL, THANKS GUYS
amit
yes really its VERY VERY VERY USE FUL AND IMPORTANT WTH EASY WAY TO UNDERSTAND
nizamudeen
very very useful example thank you your cooperation
India sucks
haha
kalpana.L
thnx 4 dis information. It is very useful n easy to learn…. Like to knw part 2 also:-)
Melissa
Thank you! This may the first time I’ve used this type of instruction to learn to use a function in Excel. (I usually have to get human help.) Your explanation was really helpful, especially since my program interface language is Spanish. (“Indicador_columnas”???) Very easy to follow your instructions.
don
you spelled Mickey wrong
sajio
thank you very much from the core of the heart !
Enid
Excellent, it is simple and useful. thanks
girish patel
very good elobration
Somakumar
Useful when required
Gayathri
Thanku soo much it was simple and so effective.
Regards,
Gayathri
Rabi Narayan Patro
it is very helpfull to me.
AJIT NAIR
Explained by many but your tutorial is very simple but more effective.Thanks a lot.
Ajay
Great Explanation.
SANTOSH KUMAR SAND
explained in very very easy way :-D
dimple
it is very simple & effective
Ashfaque Awan
It’s really helpful for me to go thru this tutorial, thanks!
Is it possible for me How to link from sheet1 data to sheet2. For example sheet1 data distribute in three column, (s.no, Name and address) I enter just any one s.no in sheet2 of first row and row 2 and row 3 pickup data from sheet1?
sorry if i didn’t word it properly, hope you understand & have time to reply me, thanks!
Jagdeep
Great explanation !
Thanks !
phchan
Very useful, the data min ascust be ending order is where I use to overlook…
sai kumar
thanks Boss i’am waiting for this now i got it thankq very much……….. it is very easy to know difficult things………..
Bipendra
Great, since long I had been trying to use Vlookup but unable to use it.
Thanks now by reading step by step I have been able to now use the Vlookup.
Vivek
Thanks a bunch! you saved me 4-5 hrs of manual job! :)
Dinesh Pal
thank you
Mohit Unadkat
Explained in a very lucid yet effective manner. thank you.
krishnamurthy
good one
Hemanth Bambure
good, very useful
ken
Great explanation!Cool stuff!
Mustafa Badshah
Very simple and easy to understand
Thank You
Mustafa Badshah
Very simple and easy to understand
Vishnu
Thanx
Dipak
it is very helpfull to me.
Hanumant S Bandgar
Wow!!!!!
Its Greatttttttttttttttt.
It is very improtant for me………
dhaval
it’s great tell me more about it & part 2 you can also mail me ragarding this i m waiting for it.
Dhaval
suraj prakash
very nice
it is so good……..
JALPA
ITS USEFUL TO KNOWING ME …
THANKS
..
HARI PRASAD
Very Needful, Thanks
SHIV SAHNI
IT IS REALLY INTRESTING AND EASY TO LEARN FROM YOU ,PLZ LET ME KNOW IF I CAN LEARN MORE..
Neha
Very useful document..
vidhi bhagade
i like it pls show me that how can we apply this formula for 2 sheets of data & show other ex.
Chris Grobler
Very clear and helpful explanation … thank you
vijay singh
very helpful…….. i have been asking my office mate so many times…… here i find it
thank you very much
prakash mukank
very useful
thanks
ankit
please 1 copy vlookup on my mail id.
RAJESH KUMAWAT
THANKS FOR HELP…………… GREAT
RAJESH KUMAWAT
NICE THIS IT IS HELPFUL TO ME……….. THANKS
Shraddha
Easy preparation before going for an interview. Thanks……
JEETENDRA VIJAYVARGIYA
very useful.
Thanks for this.
nice example put.
Ramchandra
Thank You very Much ….
It Really works …..
Peter Byrne
Hey, best vlookup explanation i’ve seen, easy to follow in plain english, cheers
Sandeep Ghalsasi
great explanation, simple to understand, thanx a lot, by the way is part II released , if not waiting eagerly
IDA
I used to be scared looking at the formulation of vlookup when it was thought to me, your explanation made it so easy to understand.
Thanks for making it easy
Great job!!!!!!!!!!!!!
Satya Prakash
Excellent!!! After such a long time, now I feel comfortable in VLOOKUP. Thank you very much……..
Samruddhi Naik
THANKS FOR HELP…….
kavitha
It,s very useful to me Thank you
GIRISH S
PLEASE HELP ME TO LEARN VLOOK FROM BASIC THANK YOU
flaviu
thanks man,
very usefull
no name given
thankyou. god bless you. :)
this came in such good use!
Diana
Excellent!!! very easy to understand _ Thanks a million
Dev
EXCELlent! Finally I learnt it :)
Thanks a lot & God bless
RATNAPRABHA
This is very useful formula in office life.
so thank you !
munaza
thank you so much this is great .GOD bless you
veer singh
Plz send me vlookup formula detail Its urgent
it’s great tell me more about it & part 2 you can also mail me ragarding this i m waiting for it.
veer singh
please 1 copy vlookup on my mail id.
PRASHANT VERMA
I found this helpful…..it is the formula of very useful.if you have something pls send…good luck.
RAMESH GAJAM
I THOUGHT VLOOK IS VERY TOUGH, BUT THE WAY YOU PRESENTED IS WORTHWHILE YAAR, NOW I FEEL SIMPLY GOOD BECAUSE I UNDERSTAND HOW VLOOK WORKS. THANKS
Amy
Its really a good and simple example. i liked it.
cloyde
superb example!
Ichcheghuri
Nice post. really its worked..
thnx
John
Loveryly
John
bestested arounds
paresh khot
Hi
Thanks for teaching Vlookup as convenient as I had never learn.
Thankssssss :)
Joe
Great tutorial, website needs a little updating but it walked through the Vlookup pretty well. I also used the link below to get on top of it.
http://analysttutorials.com/2013/03/a-simple-vlookup/
FATAI IBRAHIM
Thanks understandable in no small way !
pradeep
Thq
bhavin
realllly,
i simply understand this concept
Dhruba
In LPP we called simplex model is more complex, but your effort to make me understand about the V-Lookup is reverse one.
rohit
thanks it was very uselful
sudhanshu S
Very usefull indeed. and he best part is the way entire process has been elaborated. Good for beginers..
Rosemary Kariuki
Hi,
I have never attended an excell class and after I follow your instructions am understanding them very well. I used to hear people talking about Vlookup and no one was willing to explain but now I managed with the sample so I hope to continue all the formulas. Thanks
ritu
very well explained..:)
Keep it up..
mansoor pasha
good to have like this
Shruti
Excellent!!! Truly of great help and very comprehensive!! Thanks!!
Faheem Maqsood
Very well explained…
Really helpful for new one like me
Hlayie
Hey Man,
Well explained.
Is it possible to combine vlookup and replace?
i have this sheet with numbers that I must replace them with other numbers.
Pleas help if you can
jocab
I’m studying complex spreadsheets, was a bit stuck with homework, my v-lookup was not working & you helped me to work out why, thankyou!!
Aditya
thanks, for learn easiest process to use vlookup function
AJIT SINGH
i am grateful to you. i had been facing this problem for a long time but now it has been
solved by u.
Rita
it’s good………….
amit bhushan
Great work dude and very clear and useful.
Kim
Excellent basic tutorial!!
Lakshmi r
i want know how to do v look up in one excel to another excel.
M J Betty
hai sir,
Starting itself its very difficult to learn
but after some hours i understand verywell. and also i have some queries regarding this
kindly give a solution.
Thanks & Regards,
Betty/9840645839.
harshitha
made it very simple…thanks!
kartick
after put this formula i am getting #N/A. plz give me solution.
thanks.
kartick
it is very useful.
Arun Dany
Good
Bhaskaran`
It was very useful for beginners..
shobhit
good one.
Amit Kumar
yes this site is very helpfull form me
and i easily learn the VLookup
Jay
Thanks!!! You saved a lot of time for me!
Jay Vora
EXCEllent!!!!!!!!!!!!!!!!!
Anonymous
It helps alot…Thanks for this post…;D
somc
it is good to start with this function that looks complicate but you can present in a very easy and simple process… keep going… well done
Priya sharma
WHAT IS vlookup and hlookup and how to use it in exel sheet
KAB
Simply,its awesom…..to learn much in to short n simple.
rakesh
thanks its very usefull for me
Amber
Great…!!! Waiting for the second tutorial.
INDRA MANI YADAV
this is very good for tutor us
Vikas Sharma
It is the best way to understand to anyone.
Thank you
Rohini Jingare
It is very good & it is help a lot of my job
Thank You………..!
Deepak Singhal
Excellent ! rightly explained
sultana
it’s really helpful,thanks
Shiv
Very very helpful
asha ghadi
it is very helpful thanks
trupti naik
excellent experiance
Usman Iftikhar
Kudos to you for making vlookup look so simple !! ..gr8 job
Krati
It was awesome, I could use it first time…. I had read so many tutorials but this was very nicely written.
Please Leave a Comment!