?
Solved

VLOOKUP Formulae

Posted on 2012-09-10
3
Medium Priority
?
370 Views
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,
Shail
0
Comment
Question by:ShaileshShinde
  • 2
3 Comments
 
LVL 1

Author Comment

by:ShaileshShinde
ID: 38385648
Please find Example for this:

Sheet1:
Name Contacts
Test1   1234
Test2    5678
Test3   234

Sheet2
Name Contacts
Test2   contact no to be added here from sheet1 for name "Test2"
Test1

Open in new window

Test3
0
 
LVL 25

Accepted Solution

by:
lwadwell earned 400 total points
ID: 38385665
in sheet2, cell B2:
   =vlookup(A2,Sheet1!A:B,2,false)
copy the formula down the column
0
 
LVL 1

Author Closing Comment

by:ShaileshShinde
ID: 38385941
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

807 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