ShaileshShinde
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER
Open in new window
Test3