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...

A B OUT E X PE R I G LOT - C ON TA C T - E X C E L TUTOR I A LS - A D V E RTI S E - D I S C LA I M E R

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 P E R I ME N TS I N F I N A

Interested in Islam? www.IslamReligion.com Read, watch or ask thru 1-to-1 chat about Islam or converting to it Microsoft Office 365 www.microsoft.com/office365 Access Email, Documents & Calendars Anytime, Anywhere. Sign Up Today CAPM Preparation Course www.promantia.com 2, 3 and 4 Dec 2011 (Bangalore) 23 PDUs from a Global REP of PMI Focal Review & Rewards www.spl.com Fixed and Variable Compensation HRIS Integration

R E C E I V E E X P E R I G LOT' S P OS TS E MA I L F OR F R

NAME:

EMAI L:

MOS T POP ULA R PO

How to use nested IF statemen

Excel with AND, OR,

How to use VLOOKUP in Exce

simple tutorial (pa

If you use Excel much at your job, sooner or later, youre 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 (lets 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-mans database of sorts (a totally unscalable solution and prone to errors with every revision, but dont get me started), once you know vlookup, its likely to become one of your most often used Excel functions.
S EA R C H

How to calculate net present v

(NPV) - an introdu

How to calculate an internal ra Compound Annual Growth

return (IRR), and when not to u

(CAGR) calculator (

Asset Allocation

So, lets get started with a very simple example of what vlookup is all about. Suppose you had the following table:
Business & entrepreneurship

Corporate finance R EC OMM E N D E D F I N A N C E B LOG S All Financial Matters Blogging Away Debt Blueprint for Financial Prosperity Consumerism Commentary Dont Mess With Taxes Fat Pitch Financials Financial Nut Frank the Financially Savvy Atheist Get Rich Slowly I Will Teach You To Be Rich Mapgirls Fiscal Challenge My Money Blog Seeking Alpha The Digerati Life Excel spreadsheets (.xls) Experiglot's valuation Current events

Excel function tutorials

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:
Personal finance

Tips for saving money Value investing

Online financial calcul buying gold Contents Insurance

Vlookups format looks like the following: =vlookup(lookup value, table where values reside, column # where values are located, false) Lets 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:

1 of 28

12/11/2011 12:26 AM

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...

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. Its 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 youve 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 thats 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. (Well 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 isnt found, then vlookup conks out and returns #N/A. Though we wont 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 doesnt 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

2 of 28

12/11/2011 12:26 AM

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...

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 doesnt become A2:B6 but stays with the original range of data. This way, we can just copy whats in cell I2 down the rest of the cells (from I3 through I5):

Finally, heres 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 Ill 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 shouldnt 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

2 0 4 F EEDBA C KS O N " HO W TO U SE V LO O KU P IN EXC EL A SIM PLE TU TO RIAL ( PA RT I) "

JL P S W E E K LY ROU ND U P (W E E K OF NOV E M B E R 12 , 20 07)? ALL FINANCIAL MAT T E RS

[...] Last but not least, Ricemutt has a nice tutorial on how to use the VLOOKUP function in Excel. If you dont know what Im 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 NORE FINANCE E X PE RT S, V LOOKU P, DE BT DISE ASE , AND MAKING Y OU R DEBT KNOWN BLOGGING AWAY DEBT

3 of 28

12/11/2011 12:26 AM

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...

[...] 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

MUHAMMAD

very useful, God bless you

29 November 2007 at 2:39

RAMU

iT IS VERY USEFUL FOR ME

05 December 2007 at 1:42

CHIRAG

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

KAZI

it is very great to follow just give us more information about v lookup

25 December 2007 at 7:15

HOW T O U SE V L OOKU P IN E XCE L (PART II) - SOME T IPS AND ADV ANCE D EXCEL T RICKS | EXPE RIMENT S IN FINANCE

[...] 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 HAZ ALA

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

MARTIN

Great! Very simple and usefull explanation

10 March 2008 at 0:09

HT T P:/ / WW W.E X PE RIG L OT .COM/ ?COMME NT S_POPU P= 599

[...] writing a post about this entry http://www.experiglot.com/?comments_popup=599 Stay [...]

4 of 28

12/11/2011 12:26 AM

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...

03 April 2008 at 5:54

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. . . .

27 April 2008 at 9:12

ADITI JAISWAL

this is gr8!!, keep it up, waiting for PART-II

29 April 2008 at 4:38

MEME

trs didactique! bravo

16 May 2008 at 4:53

MANAS SRIVAST AVA

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

SUMEET CHANDRA

Kudos to you for making vlookup look so simple !! ..gr8 job

06 June 2008 at 3:38

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.

21 June 2008 at 17:00

HUCHEIN

Its a really great tutorial which explains the basic application of Vlookup in a very simple way. Thanks

02 July 2008 at 20:15

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/

5 of 28

12/11/2011 12:26 AM

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...

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

KE VIN

Thanks a ton. I just used this on a massive spreadsheet. Worked Great!

10 July 2008 at 14:54

VINOD CHINCHOLKAR

excellent info about vlook up given on this site.. hats off, gr8

01 August 2008 at 3:29

BALVANT

Simple and excellent explanation. Thanks.

07 August 2008 at 7:32

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. its so knowledgefull for me. Thanks

19 August 2008 at 19:13

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.

08 September 2008 at 9:08

AKHILESH

It was very helpful for me thanks lot and my all wishes 4 y

18 September 2008 at 9:21

FARHAD

Iam not able to make the Vlookup formula its giving me command error

21 September 2008 at 3:54

6 of 28

12/11/2011 12:26 AM

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...

JAY 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

UCKY

its amazing . tips are really very helpful!!!!!!!

30 September 2008 at 0:39

RAAZ

its awe some. its really helpful thanx

12 October 2008 at 23:58

ADNAN

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

PRASAD

i dont know abt vlookup but after viewing ur example i got it ur explanation is awesome..

16 October 2008 at 5:30

ANIL PIL L AI

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

PALANI SELVARAJ

It is one of the useful tools, Thanks to the Publisher.

28 October 2008 at 9:01

ABDEL

Great stuff. Thanks Life is simple. keep it simple.

28 October 2008 at 15:00

NIRU

Excellent

7 of 28

12/11/2011 12:26 AM

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...

29 October 2008 at 0:43

CHOWDHARY

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

OMAR

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

AHMET

thank u man, May Allah bless you from istanbul city

23 November 2008 at 11:21

SHEIKH SARWAR

I felt comfortable with your tutorial.

04 December 2008 at 8:05

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 dont 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

HARIOM

Please send me 1 copy for how to use VLOOKUP

13 January 2009 at 10:50

BHU VAN JOSHI

Spot on!!! Keep up the good work!! Waiting for more Regards!! Bhuvan

14 January 2009 at 10:56

SELIM

Its good.Really helpful.

03 February 2009 at 10:23

MIGS

8 of 28

12/11/2011 12:26 AM

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...

Sorry but I cant 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 cant make it work. If you can help I would appreciate it very much!

04 February 2009 at 22:34

VISHU

Thanks tutorial Today I learn How to create Vlookup Formula

11 February 2009 at 7:22

BRYN

I have saved your sight to my favorites. You explain in such an easy way. Good bless you.

18 February 2009 at 7:42

KEN

Its 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 didnt word it properly, hope you understand & have time to reply me, thanks!

03 March 2009 at 14:29

BHARATH

i am getting error: #NAME? so pls send me soloution .. replay me soon

04 March 2009 at 20:48

MANDEEP

Thanks it is a wonderful experience

07 March 2009 at 1:40

JAH

this site is very helpful. i understand vlookup by reading your material. thanks

13 March 2009 at 12:37

HAZE L ANN

wowwwits great to know this function. So helpful.tnx a lot!!

9 of 28

12/11/2011 12:26 AM

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 March 2009 at 10:02

PRAGAT

it s a very good system.thanks

04 April 2009 at 23:07

CCNA T RAINING _KARROX

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

LONEWOLF

great work buddy.. cheers :)

17 April 2009 at 9:05

RAHAB

Fantastic, easy to understand.

10 May 2009 at 11:15

NIA

More important than useful, I could follow through what you were saying! Thank you. NOW it becomes useful. :) I didnt really understand the $ bit though.

26 May 2009 at 1:08

DAWOOD MAMEDOFF

Hi, thanks for explanation! For simpler illustration of how vlookup works Id 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

VISHVAJEET SISODIA

hi its very nice formula for me and now iam a computer teacher and before i dont now how to create vlookup but now i learn vlookup i will waiting for next editin thaxs

03 June 2009 at 21:54

JA NE

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

10 of 28

12/11/2011 12:26 AM

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...

VE NOD RAVEE NDRAN

Thank you very much. Really save me half hour

05 June 2009 at 0:21

MARCIA MAY HEW

Finally the mystery made plain!!! Thank you Look forward to part II

07 June 2009 at 7:44

SAURABH

very useful ! Thank You

11 June 2009 at 7:07

LING

Easy to learn instructions. Thanks!

17 June 2009 at 19:17

JA NE

Finally, instructions I can understand!

19 June 2009 at 13:44

DAN

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

STAN

simple but effective thanks God bless you

16 July 2009 at 0:49

RAHUL MALPANI

11 of 28

12/11/2011 12:26 AM

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...

dear sit, i saw the vlookup practicaly formula but didnt understand completely, its 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

SEETU

very nice & simple

29 July 2009 at 2:34

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!!

01 August 2009 at 12:27

LE SLIE

Thanks for the catch and correction :)

01 August 2009 at 15:31

S GANESH

This is excellent Way of Teaching God Bless You Ganesh

04 August 2009 at 3:22

S GANESH

It is Very nice Training God bless You Ganesh

04 August 2009 at 3:24

U MU RIZ A ODE T H

this expalanation has been so simple and good. keep it up, may God bless you

06 August 2009 at 3:06

S GANESH

12 of 28

12/11/2011 12:26 AM

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...

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

WENDY

Thank you so much for your simplistic approach! God loves you :)

14 August 2009 at 16:49

V IKAS

its good for practice thanks it excellent

01 September 2009 at 2:31

HMMM

when you say highlight table with your mouse, do you mean with mikey?

21 September 2009 at 12:38

DIX IA

very nice & simple thnx

21 October 2009 at 10:45

PUNKI

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

DEE

Thank you. Life saver!!.. Done the Vlook up in no time

03 November 2009 at 9:00

V IKAS

mind blowing, god bless you

13 of 28

12/11/2011 12:26 AM

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...

04 November 2009 at 0:17

SURESH BABU

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

MUHAMMAD NASIM

Bundle of thanks it is very usefull information.

07 December 2009 at 5:11

ANUP

this is very important for me it is really very useful thank u buddy.

08 December 2009 at 16:20

THAMER

Very simple and clear. Thank you, it helps me finishing my project.

27 December 2009 at 3:41

KART HIK MANOHARAN

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

RAMKESH

wow! how nice and eassy, thanks for guidline.

19 January 2010 at 4:02

SIMON

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

AKHILESH

Finally the mystery made plain!!! Thank you Look forward to part II

18 February 2010 at 0:16

PRIYA

14 of 28

12/11/2011 12:26 AM

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...

This is nice

04 March 2010 at 11:11

MOHD RAQIB

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

POOJA SHARMA

thanks a lot dear .

13 March 2010 at 3:41

PRAVEEN G UPT 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

KOCHU

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 JIT KU L K A RNI

Its great, Thanks

27 March 2010 at 2:00

BHUPE NDER

Very good example very simple..

29 March 2010 at 3:06

JATIN SETH

Thanks alot, really helpful, now i can atleast understand basics V look up.

01 April 2010 at 2:30

BILL

15 of 28

12/11/2011 12:26 AM

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...

Good job. I finally understand the concept. Microsoft help sucks, doesnt it?

06 April 2010 at 18:27

DEVE NDER SHE KHAR

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

PET ER OVERNELL

Excellent tutorial, thanks a million. Now to deal with part II. Do you have any guidance regarding the protocol for Excel formula? Im no mathematician and find the concept of formula construction rather daunting.

07 April 2010 at 2:34

SACHIDANAND

Wonderful example! Now i can use this formulla. Sachidanand

08 April 2010 at 4:51

U JJW A L

Helped us a lot

09 April 2010 at 1:22

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

10 April 2010 at 0:56

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!

05 May 2010 at 17:24

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

07 May 2010 at 6:47

VE NGUDU SITTHAR

16 of 28

12/11/2011 12:26 AM

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...

simply awesome

16 June 2010 at 8:25

MOHIT GUPTA

very nicely explained.

30 June 2010 at 19:36

KAPIL JAIN

good site for those who have little knowledge vlookup..

03 July 2010 at 4:37

SARAH

VERY EASY TO FOLLOW, THANKYOUIS PART II OUT?

03 July 2010 at 15:13

MICHAEL ANTE

thanks very muchIt helped me solved some problems in my work. May you have some more tutorials..God bless you!

09 July 2010 at 2:05

BIRE NDER

how to use v lookup and h lookup

15 July 2010 at 4:50

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. Ive 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

KHURRUM

its confusing

26 July 2010 at 7:10

BHARAT

nice study

28 July 2010 at 0:13

17 of 28

12/11/2011 12:26 AM

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...

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.

30 July 2010 at 8:02

VENKAT

really good and ur service is praise worthy.

05 August 2010 at 2:03

ARUP

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

SK RAJU

Thank you very much, its really useful

07 November 2010 at 22:41

NITIN MAHAJAN

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

SAMEER

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

NEHA

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

KALPESH BORLE

Thank you very much, it?s really useful

19 November 2010 at 5:42

18 of 28

12/11/2011 12:26 AM

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...

ANGELA SACHDEVA

It was really useful. Thanks!!!

22 November 2010 at 13:16

VISHNU KUMAR

thank you sir god bless you

23 November 2010 at 2:53

JOHN RUANE

good start I like more advanced test

23 November 2010 at 8:28

G ARY

it was very useful in helping me complete my assignments.. Thank you so much

28 November 2010 at 12:14

ISMATULLAH

hi thank you it was very useful really appreciated godless you

29 November 2010 at 9:34

SURESH REDDY

i really appreciate who prepared this document

02 December 2010 at 5:52

BRAJESH CHAUDHARY

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

MAT

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

PART HA

19 of 28

12/11/2011 12:26 AM

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...

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

KAMAKSHI

This post is very helpful. Thank You Sooooooooooo much

13 December 2010 at 1:12

CHANCHAL

hello sir please send me some example with if condition

13 December 2010 at 4:05

KAMAKSHI

Good Afternoon Sir May you send me HLOOKUP explanation in two parts as like VLOOKUP

14 December 2010 at 0:22

CHANCHAL

Pls send me some examples of vlookup with if condition

14 December 2010 at 4:53

HINA

very very useful thanks a lot

14 December 2010 at 5:04

SUNNY

I dint understood a single thing plz help me out

19 December 2010 at 11:32

MANIKANDAN

In excel i searched in the help option but i cant understand the forumula. But your are giving very easy method its very useful for me. Thanks a lot.

31 December 2010 at 7:35

ARPAN

3 cheers to the presenter 4 an awsum job .

06 January 2011 at 23:33

20 of 28

12/11/2011 12:26 AM

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...

JACQUELINE E . COMPET ENT E

thank you so much. it gives me more knowledge about in microsoft ex.

10 January 2011 at 6:33

AMANDA

Thank you! Thank you! Thank you! This is the simpliest explanation Ive ever found, and I finally understand whats going on! Youre a life saver!

11 January 2011 at 13:44

RANITA

Very useful & easily understandable. Thanks!

12 January 2011 at 11:25

JAWED KHAN DABLU

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

MUHAMMD ALI BABRI

Its a good practice for every new learner and helpful guide for all.

27 January 2011 at 0:52

GANESH

now i feel better about vlookup

27 January 2011 at 3:47

MONJEET MUKERJEE

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

SOL OMON KU T IAME

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

PRIY ANKA

its really nice!!!!!!

21 of 28

12/11/2011 12:26 AM

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...

09 February 2011 at 7:08

AVINASH

I just try this formula, its realy great full to me

10 February 2011 at 9:37

GAU RAV

Great work yaaaaar!!!!!!!!

14 February 2011 at 7:11

SOLOMON

Dude you made it so simpleThanks a Ton.

15 February 2011 at 7:20

SAMEER

Its Wonderful Formula

17 February 2011 at 6:27

PRAVIN G.

Thanks, Its very easy. God bless you.

17 February 2011 at 18:08

IRFAN

Hey.Its really great to go through this Tutorial

22 February 2011 at 6:09

JAI HRO

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

SHAIKH QURE SHI

Very useful

01 March 2011 at 16:00

MIG U E L

Very Nice! Thanks!

22 of 28

12/11/2011 12:26 AM

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...

08 March 2011 at 11:45

PUNEET CHAWLA

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. Its been a great help for me. Keep it up and please add up more example for easy learning.

09 March 2011 at 1:10

NISHANT

I Need More example for multiple uses

09 March 2011 at 1:39

WIL LIAM W IL ST ROT H

Thanks! This is a good tutorial! Helps me a lot!

10 March 2011 at 20:29

CHANDNI

Awesome! you made it so simple, thanks God bless!

29 March 2011 at 11:46

PIY A

Thanks a lot for the simple yet very meaningful guide. Its very useful. May god bless you

03 April 2011 at 23:43

JIM

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

DEE PALI

Great work thanks

05 April 2011 at 5:58

SHUMAILA

Thank you very much . It was very easy to understand and it was explained in very simple manner..

06 April 2011 at 2:19

DEVESH CHAUDHARY

thanks a lot :) great way of explaining. thanks once again, you made it so easy to understand :)

23 of 28

12/11/2011 12:26 AM

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...

GOD BLESS YOU

10 April 2011 at 22:39

MANISH

Its very nice.

13 April 2011 at 7:37

SAT ENDER KUMAR

its great to learn himself, thanks its very easy to understand.

30 April 2011 at 4:43

PVS RE DDY

explained in a very lucid way therecannot be a better way as this is superlative many thanks

16 May 2011 at 7:40

SHAILESH

It is simple & lucid, but if had more examples with bigger data would clarify in much better way

19 May 2011 at 14:03

VIJAY

Very Nice. Thanks.

07 June 2011 at 6:01

VIJAY

very nice.

07 June 2011 at 6:02

SHILPA

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

ATTICUS

Thanks a ton. Youve been a great help

19 June 2011 at 2:41

ROH IT

24 of 28

12/11/2011 12:26 AM

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...

Finally a good explanation of VLOOKUP amidst all the other crap..good job man..great clarity..much appreciated

19 July 2011 at 2:16

KAUSHAL

Awesome article!

20 July 2011 at 6:37

ME GHRAJ BHOIR

I UNDERSTAND FEW FARTS..

23 July 2011 at 2:17

S. VANI VENITHA

Thanks a lot!!!!!! Was very helpful to solve a query. Thanks again !!!!!

29 July 2011 at 4:43

PRABHU ANT ON

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 XPE RIG L OT

@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

BALLY

wow the mystery of v lookups has been solvednot as difficult as i thought, glad i took initiative to look up v lookup!

31 July 2011 at 16:43

DELGADZZ

this is fucking shit, i didnt understand at all

05 August 2011 at 0:41

REKHA

This was very useful for me. Thanks for this artical.

05 August 2011 at 22:54

SOHAIL

25 of 28

12/11/2011 12:26 AM

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...

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

KE L V IN

Great example. Simple and Precise. I didnt have to refer twice to get my job done after going through it. Thank you.

10 August 2011 at 2:39

LUISRAEL

thank you very much, you have just saved my day!!!

15 August 2011 at 10:14

KRUTH

really superb.thank u so muchit was really easy for to catch up well

23 August 2011 at 23:18

ROSELIN JEBAKUMAR

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

TOM

Great job! Everything I needed to write my own formulas was present in your example.

02 September 2011 at 11:54

CASH COACH

Im amazed. I ask a legitimate request for help on a complicated vlookup formula and you dont 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

SOME G IRL ;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

SWET HA.BANDARI

excellent expaination

26 of 28

12/11/2011 12:26 AM

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 September 2011 at 12:40

SWET HA.BANDARI

It is very understandable thank you

23 September 2011 at 12:41

SAHIL

i didnt understand this statementthe keys should always be left to the values?????

28 September 2011 at 0:51

KAREN

Excellent..God bless youso 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

SUSHANT PRADHAN

it is very simple understanble point wise. nice thanks

06 October 2011 at 9:34

MOUNESH

Great work man . I think it ll certainly help me . Thank you

07 October 2011 at 6:11

UMA

how to create Hlookup and what is the difference between vlookup & hlookup

09 October 2011 at 1:20

SUKHVINDER SANDEEP AKASH VIKRAM

It is very understandable thank you

13 October 2011 at 6:10

SUKHVINDER SANDEEP AKASH VIKRAM

It is very very excellent understandable thank you

13 October 2011 at 8:13

100

hanks really well ecplained and usefull

13 October 2011 at 9:26

27 of 28

12/11/2011 12:26 AM

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...

PAWAN KULDIP KERKET T A

Ya its really good :)

02 November 2011 at 1:03

CHANDU

Its nice one to understand excel really helpful

09 November 2011 at 7:23

C O M M ENTS

Please Leave a Comment!

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.

28 of 28

12/11/2011 12:26 AM