Home MS Office Howtoos How to match values in Excel using Vlookup

RedditDel.icio.usGet more widgets at VivoCiti.comDiggGoogleHuggReddot@eShiok!LiveFacebookSlashdotNetscapeTechnoratiStumbleUponSpurlWistsSimpyNewsvineBlinklistFurlFarkBlogmarksYahooSmarkingNetvouzShadowsRawSugarMa.gnoliaPlugIMSquidooco.mmentsBlogMemesFeedMeLinksBlinkBitsTailranklinkaGoGo
Module is designed by http://www.vivociti.com
How to match values in Excel using Vlookup E-mail
26 May 2009

Working with different sources of data in Excel often requires us to populate the column of one table by looking up values for it in another table. This task also known as matching is easily accomplished by using Vlookup function. Below video tutorial illustrates the basic example of Vlookup use:

 

JavaScript is disabled!
To display this content, you need a JavaScript capable browser.

 

 


Comments
Search
Phil  - Very good video tutorial     |188.98.230.xxx |2009-06-01 06:46:34
:cheer:
Hi there,

very nice video tutorial. Just one question: You copied the
population data into the base table only for demonstration purposes, right? As
far as I know, this is not necessary and keeps your tables clean and tidy
:-)

What I really liked about your demonstration was the verification part with
the countif-function.
Dawood  - hi)   |79.164.123.xxx |2009-06-01 16:57:07
Phil wrote:
:cheer:
Hi there,

very nice video tutorial. Just one question: You copied
the population data into the base table only for demonstration
purposes, right? As far as I know, this is not necessary and keeps
your tables clean and tidy :-)

What I really liked about your
demonstration was the verification part with the countif-function.


yep, of course that copying is not necessary, i just did it to make my
life easier ))

thanks for feedback!
jack   |80.80.20.xxx |2009-08-19 05:22:34
Yes,
This worked well for me as well.

However I had a problem in my version
of Excel when I used " , "

I had to use " ; " instead!!!
potter05   |Registered |2009-09-05 05:06:58
Many thanks, your video tutorial was a great help, clear and
informative
regards
N
DJ  - nice tutorial   |220.227.79.xxx |2009-09-24 03:09:38
Hi buddy,
A very nice and demostrative tutorial. I am sure u must
have worked hard on this....
Willemien  - VLOOKUP #N/A   |41.19.222.xxx |2009-10-03 11:14:11
I have a source sheet which contains more that one row of the same data. I want
to use a vlookup formula in another sheet to return the surname, for example.
Could you please advice me on the formula to use?
Willemien  - FORMULA NOT CALCULATING   |41.19.222.xxx |2009-10-03 11:18:15
I have a workbook with formulas that calculates correctly.Whenever I copy this
workbook and open the copied workbook, the formulas seems as if it doesn't see
any values as it returns "0" or #N/A, although there are definately
correct values in the cell it is calculating from. could you please advise me
what to do?
sudha priyan   |155.56.68.xxx |2009-10-10 06:53:12
great one..its really useful

thanks alot
GHD  - GHD   |65.49.2.xxx |2010-02-10 23:09:34
ghd hair straighteners and CHI Flat iron are delivered around the world, try to place an order of ghd straightners.
bushhello  - discount ghd online dale     |110.82.131.xxx |2010-02-19 22:57:04
Our web collects ghd hair straighteners and CHI Flat iron.ghd straightners and chi are in stock.
bushhello     |110.82.131.xxx |2010-02-24 23:18:08
A HOT new pair of True Religion Jeans is the quickest way to update your look without overhauling your entire
wardrobe.Shopping online with great discount for the Seven jeans now.Seven for mankind this season is designed for you.Get it now.
GHD     |110.82.131.xxx |2010-03-05 02:29:52
ghd hair straighteners and CHI Flat iron outlet, CHI Irons just $78.
Only registered users can write comments!

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."
 
Copyright © 2010 myhowtoos. All Rights Reserved.
  



Related Articles:
Academics Personal blogs Technorati Profile