VLOOKUP Formulae

Posted on 2012-09-10
Last Modified: 2012-09-11
Hello Experts,

I have an excel spreadsheet with Sheet1 and Sheet2. Sheet1 contains names and there contact nos. and in sheet2 i have updated names which also exists in sheet1. I would like to look for the sheet2 names and check if sheet1 contains this name if match then copy the contact no. from sheet1 for that name.

Can you please suggest the vlookup formulae for this?

Thanks in Advance,
Question by:ShaileshShinde
    LVL 1

    Author Comment

    Please find Example for this:

    Name Contacts
    Test1   1234
    Test2    5678
    Test3   234
    Name Contacts
    Test2   contact no to be added here from sheet1 for name "Test2"

    Open in new window

    LVL 25

    Accepted Solution

    in sheet2, cell B2:
    copy the formula down the column
    LVL 1

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now