If you use Excel much at your job, sooner or later, you’re bound to need to look up values in a table. One of the most useful functions in Excel, called vlookup, does exactly that. The “V” in vlookup stands for “vertical” and “lookup” is pretty self explanatory. This function allows you to look up values in a table that are listed in column format (how most tables are laid out), given another value (let’s call this the “key”). Excel also has a sister function called hlookup (h = horizontal) that can be used to look up values in rows.
Sadly, as most companies seem to rely on Excel as a poor-man’s database of sorts (a totally unscalable solution and prone to errors with every revision, but don’t get me started), once you know vlookup, it’s likely to become one of your most often used Excel functions.
So, let’s get started with a very simple example of what vlookup is all about. Suppose you had the following table:
Given a list of names in another part of the table (in this case, column H), you want to figure out what kind of animal it is:
Vlookup’s format looks like the following:
Let’s look at each of these parts a bit closer.
The first thing that goes into the vlookup function is the thing you know (or are given) and that will be used to lookup other values. In this case, you have the names of the animals, so these are the things we know. In our example, they reside in column H, from cells H2 through H5. If we wanted to put the type of animal next to the name of the animal in column I (so I2 would correspond to the name of the animal in H2), we would insert the vlookup function there:
and put H2 as the first thing in our vlookup function:
Next, we need to know the location of the table where our values reside. These happen to be from cells A1 through B5 in this example, which we would highlight with our mouse to insert into the vlookup function. It’s very important that you include all the cells in the table.
Highlight the table with your mouse:
At the same time, the vlookup function automatically puts in the cells you’ve highlighted:
Next, we need the column number where the values are located. Always start with the first column (column A in this case) as #1 and count out to the right. In this example, the type of animal listed is in column 2, so that’s what we would need to insert in the vlookup function. Note that to use vlookup, your keys always have to be to the left of your values. (We’ll cover more of this in part II of the tutorial at a later date.)
Finally, the last attribute that vlookup takes is either “true” or “false”. I happen to always use “false”, and what this does is force vlookup to return the first exact value it finds. If that value isn’t found, then vlookup conks out and returns “#N/A”. Though we won’t use it in this example, if you select “true”, then rather than always looking for the exact value, vlookup will return the exact value if it exists, or the closest one to it that doesn’t exceed the key. (If you use “true”, you will need to sort your data in ascending order before using vlookup.)
Still with me? Again, this is what we would actually put in cells I2 if the names of the animals we have are located in cells H2 through H5:
Once we close off the parenthesis and hit “Enter”, vlookup automatically calculates:
And so on. We would continue down each cell in column I that we needed. One thing to note is to make sure that the location of your keys and values is always selected correctly. Oftentimes, as you copy-and-paste formulas all around Excel, the location of the data will also move around relative to the cell. The easiest way to prevent this is to “lock” the range of the location; in this case, we would do so by using “$A$1:$B$5″ instead of “A1:B5″. This way, as we move down column I, say, to cell I2, A1:B5 doesn’t become A2:B6 but stays with the original range of data. This way, we can just copy what’s in cell I2 down the rest of the cells (from I3 through I5):
Finally, here’s our result, after making the “$” changes and copying and pasting the formula down the rest of the column:
This has been a really simple example of vlookup, and I’ll cover a bit more in part II with another example, still simple, but with slightly more data.
Although in practice, vlookup is usually used between Excel sheets and workbooks, once you understand this example (which has been done within a single sheet), using vlookup outside the same sheet shouldn’t be much harder. Look for part II soon!
Popularity: 26% [?]
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
VENGUDU SITTHAR
simply awesome
Mohit Gupta
very nicely explained….
KAPIL JAIN
good site for those who have little knowledge vlookup…..
SARAH
VERY EASY TO FOLLOW, THANKYOU…IS PART II OUT?
michael ante
thanks very much…It helped me solved some problems in my work. May you have some more tutorials…..God bless you!
Birender
how to use v lookup and h lookup
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?
khurrum
its confusing…
bharat
nice study…
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.
venkat
really good…… and ur service is praise worthy.
Arup
Beautifully explained. It made me feel that you are providing hands on training. Thanks a lot for making learing so easy
James
Need a printer-friendly button…
sk raju
Thank you very much, it’s really useful
NITIN MAHAJAN
HELPED A LOT TO ME TO UNDERSTAND THE V LOOK UP..THANKS A LOT KEEP UP THE GREAT WORK
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 !!!.. ;)
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………
kalpesh borle
Thank you very much, it?s really useful
Angela Sachdeva
It was really useful.
Thanks!!!
vishnu kumar
thank you sir ……god bless you…
John Ruane
good start I like more advanced test
Gary
it was very useful in helping me complete my assignments……….. Thank you so much
Ismatullah
hi thank you it was very useful really appreciated godless you
suresh reddy
i really appreciate who prepared this document
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
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!.
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
kamakshi
This post is very helpful.
Thank You Sooooooooooo much
Chanchal
hello sir please send me some example with if condition
kamakshi
Good Afternoon Sir
May you send me HLOOKUP explanation in two parts as like VLOOKUP
Chanchal
Pls send me some examples of vlookup with if condition
hina
very very useful thanks a lot
Sunny
I dint understood a single thing plz help me out
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…….
Arpan
3 cheers to the presenter 4 an awsum job .
Jacqueline E. Competente
thank you so much. it gives me more knowledge about in microsoft ex.
Amanda
Thank you! Thank you! Thank you! This is the simpliest explanation I’ve ever found, and I finally understand what’s going on! You’re a life saver!
Ranita
Very useful & easily understandable. Thanks!
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.
Muhammd ALi Babri
Its a good practice for every new learner and helpful guide for all.
ganesh
now i feel better about vlookup
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…………..
SOLOMON KUTIAME
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
priyanka
it’s really nice!!!!!!
Avinash
I just try this formula, its realy great full to me
Gaurav
Great work yaaaaar!!!!!!!!
Solomon
Dude you made it so simple…Thanks a Ton.
Sameer
It’s Wonderful Formula
Pravin G.
Thanks, Its very easy.
God bless you.
irfan
Hey……….It’s really great to go through this Tutorial…
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!
SHAIKH QURESHI
Very useful
Miguel
Very Nice!
Thanks!
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. It’s been a great help for me. Keep it up and please add up more example for easy learning.
nishant
I Need More example for multiple uses
William Wilstroth
Thanks! This is a good tutorial! Helps me a lot!
chandni
Awesome! you made it so simple, thanks God bless…!
Piya
Thanks a lot for the simple yet very meaningful guide. It’s very useful.
May god bless you…
Jim
Hi Thanks buddy..! This is really very use full information and helped to resolve one quick query from business. Appriciated your effrots.
Deepali
Great work thanks
shumaila
Thank you very much . It was very easy to understand and it was explained in very simple manner..
Devesh Chaudhary
thanks a lot :)
great way of explaining. thanks once again, you made it so easy to understand :)
GOD BLESS YOU
manish
It’s very nice.
satender kumar
its great to learn himself, thanks its very easy to understand.
pvs reddy
explained in a very lucid way therecannot be a better way as this is superlative
many thanks
Shailesh
It is simple & lucid, but if had more examples with bigger data would clarify in much better way
vijay
Very Nice. Thanks.
vijay
very nice.
Shilpa
Hiiii
it is great and very easy to understand, for HR fresher MS Excel is very essential & necessary to learn vlookup
Thanks……
Atticus
Thanks a ton. You’ve been a great help
Rohit
Finally a good explanation of VLOOKUP amidst all the other crap..good job man..great clarity..much appreciated
Kaushal
Awesome article!
meghraj bhoir
I UNDERSTAND FEW FARTS..
s. vani venitha
Thanks a lot!!!!!! Was very helpful to solve a query. Thanks again !!!!!
prabhu anton
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
Experiglot
@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
bally
wow – the mystery of v lookups has been solved…………not as difficult as i thought, glad i took initiative to look up v lookup!
Delgadzz
this is fucking shit, i didnt understand at all
Rekha
This was very useful for me.
Thanks for this artical.
Sohail
Hi,
This is an excellent work for the layman like me.
Many thanks for excellent work, keep it up.
Kamran
Kelvin
Great example. Simple and Precise.
I didn’t have to refer twice to get my job done after going through it.
Thank you.
Luisrael
thank you very much, you have just saved my day!!!
kruth
really superb…….thank u so much…it was really easy for to catch up well
Roselin Jebakumar
It was really helpful, i felt it would be hard to grasp but the explanation what bit useful and simple
Tom
Great job! Everything I needed to write my own formulas was present in your example.
Cash Coach
I’m amazed. I ask a legitimate request for help on a complicated vlookup formula and you don’t post it but you let this obvious spam in with drival like “Great job! everything I need….blah blah” So go ahead and let the spammers in and ignore the people that have useful information or ask interesting questions. meh
SomeGirl;D xx
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
Swetha.Bandari
excellent expaination
Swetha.Bandari
It is very understandable thank you
Sahil
i didnt understand this statement…”the keys should always be left to the values?????
Karen
Excellent..God bless you…so simple. I was trying to grasp the concept by reviewing training materials from a class I took. No comparison.
Sushant Pradhan
it is very simple understanble point wise. nice thanks
mounesh
Great work man ….
I think it ‘ll certainly help me . Thank you
uma
how to create Hlookup and what is the difference between vlookup & hlookup
Sukhvinder Sandeep akash vikram
It is very understandable thank you
Sukhvinder Sandeep akash vikram
It is very very excellent understandable thank you
100
Тhanks really well ecplained and usefull
Pawan Kuldip Kerketta
Ya its really good… :)
chandu
Its nice one to understand excel… really helpful…
steve
Very Nice..more power!
Tony
Why didn’t I start here? It took me 2 minutes here to achieve what I wanted after spending ages on the Microsoft help pages.
Pradeep
please.
A. Poobalasingham
Excellent!!!
This was very helpful to me.
Thanks!
Bharat
Good provide more examples.
Anas Ahmad
definitely, this tutorial made me clearly understand the vlookup formula….. thank you so much
Saiyad Ansar
Thanks Actully it was usefull. need sum more examples
mathew
Very useful..Now I got a clue about V lookup. I will improve by doing some sample problems
Hema
really helpfull…excellent job…..great…got an idea about vlook..waiting for your next tutorial…keep going
thank u
suraj
Thanks a lot!
It really will help me to make my analytical work very very simple and easier.
laxman
definitely, this tutorial made me clearly understand the vlookup formula….. thank you so much
Shameem MK
Dear ,Thanks a lot …………………
how to get second part ?
Natalie
I think you meant “Mickey”
SUJIT
GREAT..!
I have nothing to say……..that it
Ajay
pl. send me vlookup formuls
JESU RAJAN
I often use vlookup but in one case i was stuck up, then i gone through your guideline i noted each & every line then i came to know were i was stuck.I was stuck doing mistakes by copy & paste formulas all around place.I rectify my mistakes now iam getting the right result.
THANK YOU MY FRIEND
Orçun
Worked well. thank you very much.
MANOJ NOIDA
It was very helpful for me thanks lot and my all wishes 4 y & Me
Deepak
Thanks. It was very helpful fro me to understand the concept of vlookup.
Please provide some more example of vlookup with different sinario.
Hemanth
Its a very good article.
Easily understood the the concept in very less time..
Thanks for the great article.
Please Leave a Comment!