I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1?
Example: Sheet 1: i have columns of name, age, sex, address
Sheet 2: I have all the columns said above but with an extra column of phone numbers.
How do I now match the phone numbers given in sheet two with the names in sheet 1.
The VLOOKUP function is very good for this job.
Put the function in spreadsheet 1 and search the same name on the worksheet 2.
The names don't need to be in the same order.
Capture the worksheet phone number 2 and bring to a spreadsheet 1.
Please, tell us if it worked for you.
If you prefer, save your file at a free site, www.speedyshare.com and put a link to download here.
It's easier to help you.