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,