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:

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:

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

***************************************************

**Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss**

***************************************************

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

## Ramendra

Nice…..

It’s great to learn yourself in easiest way ..

## DHIRAJ

Very useful info ! I leran in 10 min

waiting for next functions !!

## Best Excel Tutorial

Very good tutorial. You should also create one for Excel 2010.

## mudassir yasin

verey good job. it so ezy. try it and enjoy

## caseybrn

This was very well explained…..but for some reason (sure its me), just like someone mentioned above I’m getting #N/A using the simple example

## caseybrn

Help! This was very well explained…..but for some reason (sure its me), just like someone mentioned above I’m getting #N/A using the simple example

## himanshu

Thanx, finally i have learnt it

## Pankaj Tiwari

very use full for me thanx

## Goud Naveen

thanks buddy,

it is very helpfull to me.

## Satyendra

Greattt learning..

## ram

great work

## puvan

Thank you! i kept forgetting how to do it as i seldom use it so wrote below for reference.

VLOOKUP sample

=VLOOKUP(H2,$A$1:$B$5,2,0)

H2 > Lookup value (thing you know)

$A$1:$B$5 > Table where values reside (include all the cells), $ is used to “lock” the range of the location.

2 > Column # (column number where the values are located)

0 > False (return the exact value it finds)

## Nic

Lifesaver! Thank you so much.

## Michael

THANK F*** FOR YOU! I’m doing a “course” learning all the Office programs and I was given an activity to fiddle with VLOOKUP with NO instruction on how to make it work. I spent the last three hours trying to figure it out before I found this. Thank you so much.

## Tamara

Great example! Thanks a lot for your help

## ERIICAH

OH! ITS GREAT. I REALLY LIKE IT. AS A IT STUDENT I LEARN MORE ABOUT IN THIS SITE. THANKS A LOT. :-)

## Ben-G

it really helps….

## Rakesh

Amazing presentation. Thanx, god bless!

## P Gill

exactly what I was looking for. Explains the basic principles better than other sites found

## Dhiraj Nirwan

Thnx dear, its really help me.

Thnx very much

## srutha

Thank u somuch very useful

## supriya taware

thanks…………… it really helped

## Sidduba Nalawade

Super, and thnx a ton. very comprehensive!!

## arpit agarwal

thanks its very helped me

## Tushar Das

I have learn much vlook up through ur site thkz lot

## Rahul (R.K)

It is very good trick learnt about vlookup funstion it is very simple and short……

## ramesh

its grt to see that i learnt so quickly,,,

thanks to this website

## yeshwanth keerthi

Its very useful explanation

## jayesh raj

Thank u very much………

Its really helpful

## Samrat

Very nice tutorial.. i just learnt it in 2 mins.. very helpful

## sarvesh yadav

please send me some more example of vlookup,hlookup & some good example of pivot table

## Rohan Patil

Simply grt

## V.Praveen

It’s great

## Rajashree Upadhyaya

Really helpfull for beginners.

## Dipali Bhat

Thanks for providing good example of vlookup,it is very simple

## RAJARSHI PAUL

great presentation in a simpler steps..

## PRAVIN JAGDALE

Presented in simple to understand.

Thanks lots!!!!!!

## Pushpendu ROy

Thanks, this was very helpful !!

## MAYEL HADI

THANKYOU IT WAS REALLY INFORMATIVE!

## Suresh

superb simple explanation. we can apply this to more simple tables

## isha

I want to compare saled and outsaled data upcoming y vlookup formula,how i do plz tell,i m not getting any solution

## Amol

really thanks….

## Rahul Pathak

wow.

Thanx from the bottom of my heart.

You’re an amazing explainer.

## YADAV

WELL.

EXPLAINED WHICH MAKE EASY DATA

## Nayomi

Superb… I know how to do it now.. :-) Thanks a lot for sharing the knowledge..

## SUNIL KUMAR SHARMA

THANK YOU! IT WAS A REALY HELPFULL, THANKS AGAIN…

## Wilson Thomas

excellent !.. Thank you very much for sharing your expertise

## Thais

This is excellent. Where is part 2? I would love to see more!

## Abir

it shows your expertise as you have explained it in a very simple but effective manner. Thanks.

## Maneet Giri

thank you so much for the help. in my office people were keep on claiming to be batman for knowing the vlookup.. guess what, they just got a new ironman.

## Tea

Can’t thank you enough for breaking this down into something manageable as a starting point into the endless World of excel. Everyone at work uses it but no-one wants to share ‘the’ knowledge making tasks easier & faster for themselves. Now it’s my time to catch up on this & kick butt! Can’t thank you enough for getting me on that path : )

## Brandon J

You’re tutorial was exactly what I was looking for. Thank you very much.

## Debarpan

I was looking for tutorial on macros,h lookup and v lookup,just got that from you.a details and very helpful one indeed.

## jeetu pandit

this is simple vlookup formula

## jeetu pandit

false word not use

use (0) is true after 2,0 type

## Rajarajan

A very simple tool created for a beginner to learn. Great.

## Ashwin

Nice very easy to understand pls make the excel (example) table clear.

## Shasikant Mohanty

Name 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan Name WO (Date)

Rahul Kumar WO P P P P P Rahul Kumar

Kunal Chauhan P WO P P P P Kunal Chauhan

Chintamanis Singh P P WO P P P Chintamanis Singh

Lata Yadav P P P WO P P Lata Yadav

Naresh kumar P P P P WO P Naresh kumar

Riyaz Ahmed P P P P P WO Riyaz Ahmed

Please Slove This problem any one

## Mukesh Bagla

Thanks for This useful information!!!

## Ravi

Its amazing

## Grace

Thank you!! :)

## Jason John

Thank You

## Jay

Your post solves my work in few mins.

Really impressive efforts to understand the functionality, thankful to you.

## MOhammad Sufiyan

Thank you very much for this knowledge

And very good example

## Dwari

This is the easiest and most clear way of explaining V-look up. I referred many sites but I find very difficult to understand. Kudos to you!

## Deepthi

Thanks So much , very easy way to learn Vlookup

## Brandon

Your Network Marketing will allow you be found online by a lot of internet users. Your site was created for the blog reader and their enjoyment.

## Ashok Kumar Lenka

Very much useful.I understand immediately

## SURESH

Simple and good to learn excel.

Thnku

## Prabhakar

Excellent tutorial..easy to understand..great work..Thank you

## Prakash

Very nice…..if we use vlookup from left to right cell means its working, Suppose we use from right to left means its not working. FOr ex:-

X

001 a

002 b

003 c

004 d

Y

c

a

d

b

above I have mentioned the list. i have to fetch data from X to Y. i want get data c,a,d & b… How to get it?

Please advice me for this……!!!

## NIZAM

THIS IS EXCELLENT AND TOOO EASY….THANX A LOOOOT….NOW AM EXPERT IN THIS….

## Steven

Very Smart, Easy and User Friendly

Thanku

## vijay yadav

really its so good for me.

## Amit

i m very happy to read this ….its very useful for me…i really ud like to thanks the team which has post this information of ms excel of V lookup…….thanks

## MOHAMMED ASADULLAH KHAN

YES ITS FANTASTIC, IT MAKE MY WORK EASIER TO WORK.

THANX

## Diane

Oh wow, this tutorial was just what I needed! I understand now and my formula worked! Thankyou Leslie!

## Rajivranjan Kumar

I m very happy to read this formulla

## Taban Stephen

So nice and easy to understand.When is part 11 coming up?

## hina

It is very easy way of understanding that formula……..awesome….

## Dharmesh

Thank you very much, Its very useful

## Please Leave a Comment!