Link to home
Start Free TrialLog in
Avatar of ShaileshShinde
ShaileshShindeFlag for India

asked on

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
Avatar of ShaileshShinde
ShaileshShinde
Flag of India image

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Lee Wadwell
Lee Wadwell
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks