# How to use VLOOKUP in Excel – a simple tutorial (part I)

### Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials
***************

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

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

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

443 Feedbacks on "How to use VLOOKUP in Excel – a simple tutorial (part I)"

### 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! […]

very useful, God bless you

### RAMU

iT IS VERY USEFUL FOR ME

### Chirag

Hey Dude! Its a great one…..

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

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

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

how should I go about it.
I am learning Vlookup, through website

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

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.

its amazing ….

### Raaz

its awe some.
thanx………

Example is very good atleast for me, had no idea to how to apply this, but i need some more expample like this

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.

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

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

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

Thank you

Look forward to part II

### saurabh

very useful ! Thank You

### Ling

Easy to learn instructions. Thanks!

### Jane

Finally, instructions I can understand!

Comment:

### 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:)

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

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

Thank you

Look forward to part II

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

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

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

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

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

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

Thank you.

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

Thanks a lot!

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

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.

You explained it very nicely.

### SWARAMAN

Thanks for the example. Was really an important thing in Excel

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.

Its nice

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 .

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

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!

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

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

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 .

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.

Very simple and knowledgeble!!!!!!!!!!!!!!!

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.

thanks

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 :)

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

### janardan

thank you giving knowledge.

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

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

Explained in a very lucid yet effective manner. thank you.

good one

### Hemanth Bambure

good, very useful

### ken

Great explanation!Cool stuff!

Very simple and easy to understand
Thank You

Very simple and easy to understand

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

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

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

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

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

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.

superb example!

### Ichcheghuri

Nice post. really its worked..

thnx

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 !

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

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.

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.

### kartick

after put this formula i am getting #N/A. plz give me solution.

thanks.

### kartick

it is very useful.

### Arun Dany

Good

It was very useful for beginners..

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.

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

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

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

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

### Samrat

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

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

Simply grt

It’s great

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

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

really thanks….

### Rahul Pathak

wow.
Thanx from the bottom of my heart.
You’re an amazing explainer.

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

Its amazing

Thank you!! :)

Thank You

### Jay

Your post solves my work in few mins.

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

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?

### NIZAM

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

### Steven

Very Smart, Easy and User Friendly
Thanku

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

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

thanks a lot

### VINAY

Good one.. Superb!!! Very useful

### Gaitari

It was very helpful for me.

Lots of thanks.

This is the perfect site for everyone who hopes to understand this topic.
You know so much its almost hard to argue with you (not that I
really would want to_HaHa). You certainly put a brand new spin on a subject which has been written about for a
long time. Great stuff, just great!

### Rohan

Very well done bro, thanx for sharing as i nee it.

### SHRAVAN

thanks SIBIYA KUDZANAI

### Manoj

Thank for sharing it, But i also know the formula of Vlook up to Find Name ?

THANKS BRO..

### noorain

thanks allot.learnt vlook up in just 5minutes.Am impressed.

Thank for sharing

### Umesh Sharma

This is good learning site it is word less awesome ………………super

### Ranjbar

million thanks to you and your society.
i was begging every one to show me but no one cared for me, god bliss you.

### SURESH

Thank you, well explained

### Anaclete

you are doing an awesome job my friend… thanks

### Jailendra Kumar Poyam

excellent !..Great.. Thank you very much for sharing your expertise & knowledge in a simple way.

### SUSHING CHENG

Thank you so much for this easy-understanding and clear way on explaining this! I could finally understand this!

### Sunil bisht

How to use vlookup command in exel

### Sri Kumar Pillai

Thanks a ton….nicely explained…

### M.Mohsin Ranjha

bohat asan aur nafees tarika hy samjany ka bahi jaan

### kartike

thanx.it is very simple idea to learn use of excel for beginer.

### anil

Nice ! still to practice , any more details
if provided shall be helpful to understand
easily

Great !!!

### Pavan Chavhan

I really don’t know what abaut vlookup and hlookup but after viewing you’r example i got it. Really Youre explanation is awesome.

### in chennai for wedding|wedding photographers in chennai|good wedding photographers chennai|professional wedding photographers in chennai|best wedding photographers chennai|professional photographers for wedding in chennai|chennai based wedding photographe

Aw, this was an extremely good post. Taking a few minutes and actual effort to create a great article… but what can I say… I procrastinate a lot and don’t manage to get anything done.|

### エルバーキンコピーエルメスバーキン30コピーエルメス ボリード47,エルメス バッグ 名前,エルメス ネクタイ ピンク エルメス クラッチバッグ,エルメス バッグ コピー,エルメス バーキン コ

ブランドスーパーコピーバッグ、財布、靴、時計各種のブランドは表して、かばん複製品をコピーしますルイヴィトバッグ コピールイヴィトン財布 コピールイヴィトン長財布 コピーブランド偽物、偽物ブランド、ルイヴィトンコピー、 ロレックスコピー、シャネルコピー、グッチコピー、エルメスコピー、 ボッテガ?ヴェネタコピー、 バーバリーコピー、ミュウミュウコピー、トリーバーチコピー、バレンシアガコピー、ディオールコピー、ブルガリコピー、ブラダコピー、 ドルチェ＆ガッバーナコピー、オメガコピー、フランク ミュラーコピー、gagaコピー。ルイヴィトン 時計 コピールイヴィトン 靴 コピールイヴィトン アクセサリー コピールイヴィトン 小物入れ コピールイヴィトン コインケース当店の全ての商品は、全部一番安い値段で販売いたします！ご来店を期待しております!
エルバーキンコピーエルメスバーキン30コピーエルメス ボリード47,エルメス バッグ 名前,エルメス ネクタイ ピンク エルメス クラッチバッグ,エルメス バッグ コピー,エルメス バーキン コピー エルメス 財布 ダミエ オークション,エルメス ヨーロッパ,エルメス エールライン エルメス クラッチ激安通販、高い品質、送料無料。バーキン25コピー、バーキン30コピー、バーキン35コピー、バーキン40コピーなど世界中有名なブランドレプリカを格安で通販しております。N級品スーパーコピーブランドは ブランドスーパーコピー超N品エルメスバッグ,エルメス バーキン25 , バーキン30.バーキン35.バーキン40. エルメス(HERMES) ケリー http://www.gowatchs.com/brand-258.html

### スーパーコピーブランド格安販売店はこちらへ！品々の激安価格に持ったスーパーコピーブランド 代引きの新作はお客様に提供されます。安心、迅速、確実、お客様の手元にお届け致しま

ブランドスーパーコピーバッグ、財布、時計プラダ スーパーコピー,プラダ 財布 コピー,プラダ 新作 財布ブランド財布コピー，ブランド スーパーコピー 財布,プラダ スーパーコピー 財布，シャネル財布コピールイヴィトン 財布 コピー,ルイヴィトン 財布 コピー 代引き,ルイヴィトン財布スーパーコピー,ルイヴィトン 財布 スーパーコピー 代引き,ヴィトン財布代引き,ヴィトン財布 人気,ヴィトン財布 激安,モノグラム 財布，マルチカラー 財布，ルイヴィトン財布新作，ルイヴィトン バッグ 新作，ルイヴィトン スーパーコピー 即日発送ルイヴィトン スーパーコピー 専門店ルイヴィトン スーパーコピー バッグルイヴィトン スーパーコピー 財布ルイヴィトン スーパーコピー 長財布2015年新作 ルイヴィトン スーパーコピールイヴィトン コピー,ルイヴィトン コピー 財布,ルイヴィトン コピー バッグ
スーパーコピーブランド格安販売店はこちらへ！品々の激安価格に持ったスーパーコピーブランド 代引きの新作はお客様に提供されます。安心、迅速、確実、お客様の手元にお届け致します。★弊社は9年の豊富な経験と実績を持っております。★一流の素材を選択し、精巧な作り方でまるで本物のようなな製品を造ります。★品質を重視、納期も厳守、お客様第一主義を貫きは当社の方針です。★驚きの低価格で商品をお客様に提供致します！★早速に購入へようこそ！ http://www.gginza.com/bag/chanel/index.html

### Ifsc search

Search ifsc code of all banks in India.