how to use vlookup in excel – a simple tutorial part i
TRANSCRIPT
SEARCH
RECOMMENDED FINANCE BLOGS
All Financial Matters
Blogging Away Debt
Blueprint for Financial Prosperity
Consumerism Commentary
Don’t Mess With Taxes
Fat Pitch Financials
Financial Nut
Frank the Financially Savvy Atheist
Get Rich Slowly
I Will Teach You To Be Rich
Mapgirl’s Fiscal Challenge
My Money Blog
Seeking Alpha
The Digerati Life
buying gold
Contents Insurance
« One way to get guaranteed lottery winnings
How to use VLOOKUP in Excel (part II) – some tips and advanced Excel tricks »
How to use VLOOKUP in Excel – a simple tutorial (part I)
E X C E L F U N C T I O N T U T O R I A L S
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:
=vlookup(lookup value, table where values reside, column # where values are located, false)
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:
EXPERIMENTS IN FINANCE
RECEIVE EXPERIGLOT'S POSTS BY
EMAIL FOR FREE!
NAME:
EMAIL:
MOST POPULAR POSTS
How to use nested IF statements in
Excel with AND, OR, NOT
How to use VLOOKUP in Excel - a
simple tutorial (part I)
How to calculate net present value
(NPV) - an introduction
How to calculate an internal rate of
return (IRR), and when not to use it
Compound Annual Growth Rate
(CAGR) calculator (.xls)
Asset Allocation
Business & entrepreneurship
Corporate finance
Current events
Excel function tutorials
Excel spreadsheets (.xls)
Experiglot's valuation
Personal finance
Tips for saving money
Value investing
Online financial calculators
ABOUT EXPERIGLOT - CONTACT - EXCEL TUTORIALS - ADVERTISE - DISCLAIMER
Interested in Islam? www.IslamReligion.comRead, watch or ask thru 1-to-1 chat about Islam or
converting to it
Microsoft® Office 365 www.microsoft.com/office365Access Email, Documents & Calendars Anytime,
Anywhere. Sign Up Today
CAPM Preparation Course www.promantia.com2, 3 and 4 Dec 2011 (Bangalore) 23 PDUs from a
Global REP of PMI
Focal Review & Rewards www.spl.comFixed and Variable Compensation HRIS Integration
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
1 of 28 12/11/2011 12:26 AM
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
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
2 of 28 12/11/2011 12:26 AM
located in cells H2 through H5:
=vlookup(H2, A1:B5, 2, false)
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: 27% [?]
Posted on 19 November 2007 by Leslie Please leave a Comment! Pings are currently off.
Related posts:
Using Excel Sumif or Vlookup Functions
New! Excel and finance consultations for small businesses
How to create drop-down lists in Excel
How To Use The Excel Match Function
204 FEEDBACKS ON "HOW TO USE VLOOKUP IN EXCEL – A SIMPLE TUTORIAL (PART I)"
JL P ’ S W E E K L Y R O U N D U P ( W E E K O F N O V E M B E R 1 2 , 2 0 0 7 ) — ?A L L F I N A N C IA L M A T T E R S
[...] 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] [...]
19 November 2007 at 18:56
IG N O R E F IN A N C E E X PE R T S , V L O O K U P , D E B T D I S E A S E , A N D M A K I N G Y O U RD E B T K N O W N » B L O G G I N G A W A Y D E B T
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
3 of 28 12/11/2011 12:26 AM
[...] Ricemutt wrote a great tutorial on how to use the VLOOKUP function in Excel. If you use Excel, this is a
super-handy tool! [...]
23 November 2007 at 21:53
M U H A M M A D
very useful, God bless you
29 November 2007 at 2:39
RA M U
iT IS VERY USEFUL FOR ME
05 December 2007 at 1:42
C H I R A G
Hey Dude! Its a great one…..
I m pleased with your work…
Please published second tutorial please…
for that thx in Advance.
13 December 2007 at 0:17
K A Z I
it is very great to follow just give us more information about v lookup
25 December 2007 at 7:15
H O W T O U S E V L O O K U P I N E X C E L ( PA R T II ) - S O M E T I PS A N D A D V A N C E DE X C E L T R I C K S | E X PE RI M E N T S I N F I N A N C E
[...] Business Promotional Item fasb 141 valuation credit repair var site=”sm7ricemutt” « How to use VLOOKUP
in Excel – a simple tutorial (part I) [...]
27 December 2007 at 19:47
G H A Z A L A
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.
17 January 2008 at 15:34
M A R T I N
Great! Very simple and usefull explanation
10 March 2008 at 0:09
H T T P : / / W W W . E X PE R IG L O T . C O M / ? C O M M E N T S _ PO P U P= 5 9 9
[...] writing a post about this entry http://www.experiglot.com/?comments_popup=599 Stay [...]
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
4 of 28 12/11/2011 12:26 AM
03 April 2008 at 5:54
A N D Y
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. . . .
27 April 2008 at 9:12
A D I T I J A I S W A L
this is gr8!!, keep it up,
waiting for PART-II
29 April 2008 at 4:38
M E M E
très didactique! bravo
16 May 2008 at 4:53
M A N A S S RI V A S T A V A
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
27 May 2008 at 4:21
S U M E E T C H A N D R A
Kudos to you for making vlookup look so simple !! ..gr8 job
06 June 2008 at 3:38
T I M
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.
21 June 2008 at 17:00
H U C H E I N
Its a really great tutorial which explains the basic application of Vlookup in a very simple way.
Thanks
02 July 2008 at 20:15
S U S A N L E W
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/
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
5 of 28 12/11/2011 12:26 AM
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
07 July 2008 at 2:14
K E V I N
Thanks a ton. I just used this on a massive spreadsheet. Worked Great!
10 July 2008 at 14:54
V I N O D C H I N C H O L K A R
excellent info about vlook up given on this site.. hat’s off, gr8
01 August 2008 at 3:29
B A L V A N T
Simple and excellent explanation.
Thanks.
07 August 2008 at 7:32
S A H I L
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
19 August 2008 at 19:13
N E N A
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.
08 September 2008 at 9:08
A K H I L E S H
It was very helpful for me thanks lot and my all wishes 4 y
18 September 2008 at 9:21
F A R H A D
Iam not able to make the Vlookup formula its giving me command error
21 September 2008 at 3:54
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
6 of 28 12/11/2011 12:26 AM
J A Y C
This tutorial is clear and concise. Safe for that! I think you should also write a tutorial about pivot tables as well.
26 September 2008 at 17:48
£ U C K Y
its amazing ….
tips are really very helpful…!!!!!!!
30 September 2008 at 0:39
R A A Z
its awe some.
its really helpful
thanx………
12 October 2008 at 23:58
A D N A N
Example is very good atleast for me, had no idea to how to apply this, but i need some more expample like this
14 October 2008 at 23:45
PR A S A D
i dont know abt vlookup but after viewing ur example i got it
ur explanation is awesome………..
16 October 2008 at 5:30
A N IL P IL L A I
Thank you, for your valueable example to start up and for finding a valueable reports in no time.
Warm Regards
Anil
22 October 2008 at 6:11
PA L A N I S E L V A R A J
It is one of the useful tools, Thanks to the Publisher.
28 October 2008 at 9:01
A B D E L
Great stuff. Thanks
Life is simple. keep it simple.
28 October 2008 at 15:00
N I R U
Excellent
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
7 of 28 12/11/2011 12:26 AM
29 October 2008 at 0:43
C H O W D H A R Y
very very useful for any person who has the zeal to learn, but have no money.
I really appreciate you service…………
29 October 2008 at 17:07
O M A R
hey bro.. great work.. thanks for the simplified yet understandable tutorial.. much better than what my prof at
uni taught.. thanks.. :)
10 November 2008 at 23:50
A H M E T
thank u man, May Allah bless you
from istanbul city
23 November 2008 at 11:21
S H E I K H S A R W A R
I felt comfortable with your tutorial.
04 December 2008 at 8:05
S Y E D Z A H I D H U S S A I N S H A H
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.
05 December 2008 at 3:28
H A RI O M
Please send me 1 copy for how to use VLOOKUP
13 January 2009 at 10:50
B H U V A N J O S H I
Spot on!!! Keep up the good work!! Waiting for more …
Regards!!
Bhuvan
14 January 2009 at 10:56
S E L I M
It’s good.Really helpful.
03 February 2009 at 10:23
M I G S
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
8 of 28 12/11/2011 12:26 AM
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!
04 February 2009 at 22:34
V I S H U
Thanks tutorial
Today I learn How to create Vlookup
Formula
11 February 2009 at 7:22
B R Y N
I have saved your sight to my favorites.
You explain in such an easy way. Good bless you.
18 February 2009 at 7:42
K E N
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!
03 March 2009 at 14:29
B H A R A T H
i am getting error: #NAME?
so pls send me soloution ..
replay me soon…
04 March 2009 at 20:48
M A N D E E P
Thanks it is a wonderful experience
07 March 2009 at 1:40
J A H
this site is very helpful. i understand vlookup by reading your material. thanks
13 March 2009 at 12:37
H A Z E L A N N
wowww…it’s great to know this function. So helpful….tnx a lot!!
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
9 of 28 12/11/2011 12:26 AM
23 March 2009 at 10:02
PR A G A T
it ‘s a very good system.thank’s
04 April 2009 at 23:07
C C N A T R A IN IN G _ K A R R O X
My work demands the use of Vlookup function and now I can use it easily. Thanks for simplified information.
16 April 2009 at 0:00
L O N E W O L F
great work buddy.. cheers :)
17 April 2009 at 9:05
RA H A B
Fantastic, easy to understand.
10 May 2009 at 11:15
N I A
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.
26 May 2009 at 1:08
D A W O O D M A M E D O F F
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
26 May 2009 at 12:57
V I S H V A J E E T S I S O D I A
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
03 June 2009 at 21:54
JA N E
This is so much more easier to learn than looking up in Microsoft web site. Really appreciate the tutorial.
04 June 2009 at 8:56
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
10 of 28 12/11/2011 12:26 AM
V E N O D R A V E E N D R A N
Thank you very much.
Really save
me half hour
05 June 2009 at 0:21
M A R C I A M A Y H E W
Finally the mystery made plain!!!
Thank you
Look forward to part II
07 June 2009 at 7:44
S A U R A B H
very useful ! Thank You
11 June 2009 at 7:07
L I N G
Easy to learn instructions. Thanks!
17 June 2009 at 19:17
JA N E
Finally, instructions I can understand!
19 June 2009 at 13:44
D A N
Very helpful. Thanks.
Comment:
“$A$1:$B$1? instead of “A1:B5?
should read
“$A$1:$B$5? instead of “A1:B5?.
02 July 2009 at 11:48
S T A N
simple but effective thanks God bless you
16 July 2009 at 0:49
RA H U L M A L PA N I
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
11 of 28 12/11/2011 12:26 AM
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.
24 July 2009 at 8:34
S E E T U
very nice & simple
29 July 2009 at 2:34
L E O N A R D
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!!
01 August 2009 at 12:27
L E S L I E
Thanks for the catch and correction :)
01 August 2009 at 15:31
S G A N E S H
This is excellent Way of Teaching
God Bless You
Ganesh
04 August 2009 at 3:22
S G A N E S H
It is Very nice Training
God bless You
Ganesh
04 August 2009 at 3:24
U M U R IZ A O D E T H
this expalanation has been so simple and good. keep it up, may God bless you
06 August 2009 at 3:06
S G A N E S H
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
12 of 28 12/11/2011 12:26 AM
It is very nice to learn in the easy way
can u give notes on excel macro
it will be useful for me
06 August 2009 at 8:35
W E N D Y
Thank you so much for your simplistic approach! God loves you :)
14 August 2009 at 16:49
V IK A S
its good for practice thanks it excellent
01 September 2009 at 2:31
H M M M
when you say highlight table with your mouse, do you mean with mikey?
21 September 2009 at 12:38
D IX I A
very nice & simple
thnx
21 October 2009 at 10:45
PU N K I
Bless you indeed:)
You made it really easy to understand, thank you for educating the masses for Free!!!
Best wishes:)
P
29 October 2009 at 9:03
JA M E S
very very very much thanks for this example
31 October 2009 at 7:34
D E E
Thank you. Life saver!!.. Done the Vlook up in no time
03 November 2009 at 9:00
V IK A S
mind blowing, god bless you
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
13 of 28 12/11/2011 12:26 AM
04 November 2009 at 0:17
S U R E S H B A B U
thank you very much, it is very good for practice, once again thank you very much for sharing your thought with
us
05 November 2009 at 3:09
M U H A M M A D N A S I M
Bundle of thanks it is very usefull information.
07 December 2009 at 5:11
A N U P
this is very important for me it is really very useful thank u buddy……….
08 December 2009 at 16:20
T H A M E R
Very simple and clear. Thank you, it helps me finishing my project.
27 December 2009 at 3:41
K A R T H I K M A N O H A RA N
I have used, Its really amzing that i have learned it very quickly and easily, Thanks a lot… Great work……
01 January 2010 at 0:03
RA M K E S H
wow! how nice and eassy,
thanks for guidline.
19 January 2010 at 4:02
S I M O N
I had been able to do it without understanding, this means I now understand how I did it, thanks
16 February 2010 at 10:52
A K H I L E S H
Finally the mystery made plain!!!
Thank you
Look forward to part II
18 February 2010 at 0:16
PR I Y A
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
14 of 28 12/11/2011 12:26 AM
This is nice
04 March 2010 at 11:11
M O H D RA Q I B
Respected Dear
Thank You very much
I was searching this from very long time.
so thanks again
bay bay
06 March 2010 at 23:03
PO O J A S H A R M A
thanks a lot dear ………….
13 March 2010 at 3:41
P RA V E E N G U PT A
Dear Sir, its a easy and step by step way to learn how to use VLOOKUP…
keep it up
thanks!
13 March 2010 at 21:07
K O C H U
Hey Thanks for this. Really simple and well done!!
Have a job interview and this is one of the requirements. Thanks Leslie!!
26 March 2010 at 12:03
A JI T K U L K A RN I
Its great,
Thanks
27 March 2010 at 2:00
B H U PE N D E R
Very good example very simple……..
29 March 2010 at 3:06
J A T I N S E T H
Thanks alot, really helpful, now i can atleast understand basics V look up.
01 April 2010 at 2:30
B I L L
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
15 of 28 12/11/2011 12:26 AM
Good job. I finally understand the concept. Microsoft help sucks, doesn’t it?
06 April 2010 at 18:27
D E V E N D E R S H E K H A R
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…
07 April 2010 at 0:36
PE T E R O V E RN E L L
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.
07 April 2010 at 2:34
S A C H I D A N A N D
Wonderful example!
Now i can use this formulla.
Sachidanand
08 April 2010 at 4:51
U J JW A L
Helped us a lot
09 April 2010 at 1:22
M O H A M M A D A M E E N
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
10 April 2010 at 0:56
K A T H Y
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!
05 May 2010 at 17:24
T O M
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
07 May 2010 at 6:47
V E N G U D U S I T T H A R
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
16 of 28 12/11/2011 12:26 AM
simply awesome
16 June 2010 at 8:25
M O H I T G U P T A
very nicely explained….
30 June 2010 at 19:36
K A PI L J A I N
good site for those who have little knowledge vlookup…..
03 July 2010 at 4:37
S A RA H
VERY EASY TO FOLLOW, THANKYOU…IS PART II OUT?
03 July 2010 at 15:13
M I C H A E L A N T E
thanks very much…It helped me solved some problems in my work. May you have some more tutorials…..God
bless you!
09 July 2010 at 2:05
B I RE N D E R
how to use v lookup and h lookup
15 July 2010 at 4:50
N E T A
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?
21 July 2010 at 16:50
K H U RR U M
its confusing…
26 July 2010 at 7:10
B H A RA T
nice study…
28 July 2010 at 0:13
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
17 of 28 12/11/2011 12:26 AM
E L I S S A
Thank you for this resource! It was much easier to follow and described each step more in-depth than most other
LOOKUP how-tos.
30 July 2010 at 8:02
V E N K A T
really good…… and ur service is praise worthy.
05 August 2010 at 2:03
A R U P
Beautifully explained. It made me feel that you are providing hands on training. Thanks a lot for making learing
so easy
06 August 2010 at 23:48
JA M E S
Need a printer-friendly button…
19 August 2010 at 10:38
S K R A J U
Thank you very much, it’s really useful
07 November 2010 at 22:41
N I T I N M A H A J A N
HELPED A LOT TO ME TO UNDERSTAND THE V LOOK UP..THANKS A LOT KEEP UP THE GREAT WORK
08 November 2010 at 6:41
S A M E E R
Thank you Very Much for this Tutorial, I have applied this formula of V-Lookup at work on Excel Sheet that had
19,000 Entries!! and it Worked !!!
Thank you Sooo Much as this has Done Almost All of My Work !!!.. ;)
08 November 2010 at 9:12
N E H A
had read so many procedures to use vlookup, but i guess this was the simplest way to learn how to use it. As this
used the simplest language as per the users understanding …….thanks a lot………
11 November 2010 at 22:24
K A L P E S H B O R L E
Thank you very much, it?s really useful
19 November 2010 at 5:42
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
18 of 28 12/11/2011 12:26 AM
A N G E L A S A C H D E V A
It was really useful.
Thanks!!!
22 November 2010 at 13:16
V I S H N U K U M A R
thank you sir ……god bless you…
23 November 2010 at 2:53
J O H N R U A N E
good start I like more advanced test
23 November 2010 at 8:28
G A R Y
it was very useful in helping me complete my assignments……….. Thank you so much
28 November 2010 at 12:14
I S M A T U L L A H
hi thank you it was very useful really appreciated godless you
29 November 2010 at 9:34
S U R E S H RE D D Y
i really appreciate who prepared this document
02 December 2010 at 5:52
B RA J E S H C H A U D H A RY
Sir ,
This is Brajesh , i satisfy with taht formula
it is very easy to find value but i want find value of more than one column..plz send me formula with example.
Thank You
08 December 2010 at 3:29
M A T
How can I use this with other sheets. I tried putting in Sheet # in the formula but it doesnt seem to work. I got
#REF!.
08 December 2010 at 13:39
PA R T H A
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
19 of 28 12/11/2011 12:26 AM
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
11 December 2010 at 4:24
K A M A K S H I
This post is very helpful.
Thank You Sooooooooooo much
13 December 2010 at 1:12
C H A N C H A L
hello sir please send me some example with if condition
13 December 2010 at 4:05
K A M A K S H I
Good Afternoon Sir
May you send me HLOOKUP explanation in two parts as like VLOOKUP
14 December 2010 at 0:22
C H A N C H A L
Pls send me some examples of vlookup with if condition
14 December 2010 at 4:53
H I N A
very very useful thanks a lot
14 December 2010 at 5:04
S U N N Y
I dint understood a single thing plz help me out
19 December 2010 at 11:32
M A N I K A N D A N
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…….
31 December 2010 at 7:35
A RPA N
3 cheers to the presenter 4 an awsum job .
06 January 2011 at 23:33
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
20 of 28 12/11/2011 12:26 AM
J A C Q U E L I N E E . C O M PE T E N T E
thank you so much. it gives me more knowledge about in microsoft ex.
10 January 2011 at 6:33
A M A N D A
Thank you! Thank you! Thank you! This is the simpliest explanation I’ve ever found, and I finally understand
what’s going on! You’re a life saver!
11 January 2011 at 13:44
R A N I T A
Very useful & easily understandable. Thanks!
12 January 2011 at 11:25
J A W E D K H A N D A B L U
Sir ,
This is Jawed, i satisfy with taht formula
it is very easy to find value but i want find value of more than one column..plz send me formula with example.
Thank You..Very Much..God Bless u.
24 January 2011 at 9:24
M U H A M M D A L I B A B R I
Its a good practice for every new learner and helpful guide for all.
27 January 2011 at 0:52
G A N E S H
now i feel better about vlookup
27 January 2011 at 3:47
M O N J E E T M U K E RJ E E
Great! Absolutely stunning & easy to understand tutorial. I think Microsoft should learn something about
tutorials from this. The built- in Excel help is so complicated and leaves one more confused than before. Please
keep it up…………..
29 January 2011 at 9:09
S O L O M O N K U T IA M E
U bailed me out. Entry into advanced excel and am having so much difficulty. Thank God I got an easy to use
guide. Bravo. Now Complex V/Hlookup and Scenarios pls
05 February 2011 at 6:36
P RI Y A N K A
it’s really nice!!!!!!
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
21 of 28 12/11/2011 12:26 AM
09 February 2011 at 7:08
A V I N A S H
I just try this formula, its realy great full to me
10 February 2011 at 9:37
G A U RA V
Great work yaaaaar!!!!!!!!
14 February 2011 at 7:11
S O L O M O N
Dude you made it so simple…Thanks a Ton.
15 February 2011 at 7:20
S A M E E R
It’s Wonderful Formula
17 February 2011 at 6:27
PRA V I N G .
Thanks, Its very easy.
God bless you.
17 February 2011 at 18:08
I RF A N
Hey……….It’s really great to go through this Tutorial…
22 February 2011 at 6:09
J A I H R O
This was the best ever! I wish my teacher could have kept it this simple. You just saved me hours of cross
checking. Bless you!
23 February 2011 at 20:24
S H A I K H Q U RE S H I
Very useful
01 March 2011 at 16:00
M IG U E L
Very Nice!
Thanks!
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
22 of 28 12/11/2011 12:26 AM
08 March 2011 at 11:45
P U N E E T C H A W L A
It really a great tutorial, I have been searching this from the past few days but the examples that I found were
very complicated. Great work dude. It’s been a great help for me. Keep it up and please add up more example for
easy learning.
09 March 2011 at 1:10
N I S H A N T
I Need More example for multiple uses
09 March 2011 at 1:39
W I L L I A M W IL S T R O T H
Thanks! This is a good tutorial! Helps me a lot!
10 March 2011 at 20:29
C H A N D N I
Awesome! you made it so simple, thanks God bless…!
29 March 2011 at 11:46
PI Y A
Thanks a lot for the simple yet very meaningful guide. It’s very useful.
May god bless you…
03 April 2011 at 23:43
JI M
Hi Thanks buddy..! This is really very use full information and helped to resolve one quick query from business.
Appriciated your effrots.
04 April 2011 at 5:26
D E E PA L I
Great work thanks
05 April 2011 at 5:58
S H U M A I L A
Thank you very much . It was very easy to understand and it was explained in very simple manner..
06 April 2011 at 2:19
D E V E S H C H A U D H A R Y
thanks a lot :)
great way of explaining. thanks once again, you made it so easy to understand :)
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
23 of 28 12/11/2011 12:26 AM
GOD BLESS YOU
10 April 2011 at 22:39
M A N I S H
It’s very nice.
13 April 2011 at 7:37
S A T E N D E R K U M A R
its great to learn himself, thanks its very easy to understand.
30 April 2011 at 4:43
P V S RE D D Y
explained in a very lucid way therecannot be a better way as this is superlative
many thanks
16 May 2011 at 7:40
S H A I L E S H
It is simple & lucid, but if had more examples with bigger data would clarify in much better way
19 May 2011 at 14:03
V I J A Y
Very Nice. Thanks.
07 June 2011 at 6:01
V I J A Y
very nice.
07 June 2011 at 6:02
S H I L PA
Hiiii
it is great and very easy to understand, for HR fresher MS Excel is very essential & necessary to learn vlookup
Thanks……
16 June 2011 at 7:52
A T T I C U S
Thanks a ton. You’ve been a great help
19 June 2011 at 2:41
RO H IT
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
24 of 28 12/11/2011 12:26 AM
Finally a good explanation of VLOOKUP amidst all the other crap..good job man..great clarity..much appreciated
19 July 2011 at 2:16
K A U S H A L
Awesome article!
20 July 2011 at 6:37
M E G H R A J B H O I R
I UNDERSTAND FEW FARTS..
23 July 2011 at 2:17
S . V A N I V E N I T H A
Thanks a lot!!!!!! Was very helpful to solve a query. Thanks again !!!!!
29 July 2011 at 4:43
PR A B H U A N T O N
it is very easy to learn excel. in this formula why you put 2 before false and what is the meaning of 2 in this
formula , why you put false what is the function of false
30 July 2011 at 7:00
E X P E R IG L O T
@Prabhu – the 2 is for the column that you are looking for and false means to return an error is the looked for
value is not found
30 July 2011 at 10:06
B A L L Y
wow – the mystery of v lookups has been solved…………not as difficult as i thought, glad i took initiative to look up
v lookup!
31 July 2011 at 16:43
D E L G A D Z Z
this is fucking shit, i didnt understand at all
05 August 2011 at 0:41
R E K H A
This was very useful for me.
Thanks for this artical.
05 August 2011 at 22:54
S O H A I L
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
25 of 28 12/11/2011 12:26 AM
Hi,
This is an excellent work for the layman like me.
Many thanks for excellent work, keep it up.
Kamran
07 August 2011 at 0:58
K E L V IN
Great example. Simple and Precise.
I didn’t have to refer twice to get my job done after going through it.
Thank you.
10 August 2011 at 2:39
L U I S R A E L
thank you very much, you have just saved my day!!!
15 August 2011 at 10:14
K R U T H
really superb…….thank u so much…it was really easy for to catch up well
23 August 2011 at 23:18
R O S E L I N J E B A K U M A R
It was really helpful, i felt it would be hard to grasp but the explanation what bit useful and simple
30 August 2011 at 3:45
T O M
Great job! Everything I needed to write my own formulas was present in your example.
02 September 2011 at 11:54
C A S H C O A C H
I’m amazed. I ask a legitimate request for help on a complicated vlookup formula and you don’t post it but you
let this obvious spam in with drival like “Great job! everything I need….blah blah” So go ahead and let the
spammers in and ignore the people that have useful information or ask interesting questions. meh
09 September 2011 at 22:02
S O M E G IR L ; D X X
DUDE..THAT WAS TOTALLY AMAZING THANKS SO MUCH.. it really helped ..i need it to explain stuff i was stuck
on in my GCSE!!! :L xx luv yu lotss babee..xx
15 September 2011 at 16:23
S W E T H A . B A N D A R I
excellent expaination
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
26 of 28 12/11/2011 12:26 AM
23 September 2011 at 12:40
S W E T H A . B A N D A R I
It is very understandable thank you
23 September 2011 at 12:41
S A H I L
i didnt understand this statement…”the keys should always be left to the values?????
28 September 2011 at 0:51
K A R E N
Excellent..God bless you…so simple. I was trying to grasp the concept by reviewing training materials from a
class I took. No comparison.
05 October 2011 at 1:32
S U S H A N T PR A D H A N
it is very simple understanble point wise. nice thanks
06 October 2011 at 9:34
M O U N E S H
Great work man ….
I think it ‘ll certainly help me . Thank you
07 October 2011 at 6:11
U M A
how to create Hlookup and what is the difference between vlookup & hlookup
09 October 2011 at 1:20
S U K H V I N D E R S A N D E E P A K A S H V I K R A M
It is very understandable thank you
13 October 2011 at 6:10
S U K H V I N D E R S A N D E E P A K A S H V I K R A M
It is very very excellent understandable thank you
13 October 2011 at 8:13
1 0 0
Тhanks really well ecplained and usefull
13 October 2011 at 9:26
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
27 of 28 12/11/2011 12:26 AM
PA W A N K U L D I P K E R K E T T A
Ya its really good… :)
02 November 2011 at 1:03
C H A N D U
Its nice one to understand excel… really helpful…
09 November 2011 at 7:23
COMMENTS
Please Leave a Comment!
Your Name:
Your Email (will not be shown):
Your Website:
Please notify me in case of further comments!
Please note: Comments may be moderated. It may take a while for them to show on the page.
How to use VLOOKUP in Excel – a simple tutorial (part I) | Experiment... http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a...
28 of 28 12/11/2011 12:26 AM