VLOOKUP Formulae

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
LVL 1
ShaileshShindeAsked:
Who is Participating?
 
lwadwellConnect With a Mentor Commented:
in sheet2, cell B2:
   =vlookup(A2,Sheet1!A:B,2,false)
copy the formula down the column
0
 
ShaileshShindeAuthor Commented:
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
 
ShaileshShindeAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.