July 7, 2009 8:50 AM Subscribe
I need to merge two Excel sheets with some common fields, but the most advanced formula I've ever used is Autosum.
posted by thebazilist to computers & internet (9 answers total) 2 users marked this as a favorite
I have two worksheets. One has a list of people that I've invited to an event. The other has a much larger list of people, including the people on the 1st sheet, which has a field for phone numbers. I'd like to bring the phone numbers from the 2nd sheet into the 1st sheet, but only for the people who are on the 1st sheet. Both sheets have "First Name" and "Last Name."
I've been googling around and have found things about vlookup and concatenating (same thing?). I've never used vlookup before, so I guess I'd need a basic primer in vlookup and/or how to use it in this specific instance to achieve what I want. Unless there's a better solution. I've also read about maybe pulling the two sheets into Access, but I'd rather not have too complicated an end-product since very tech-unsavvy people will need to be using the results.
On both sheets, Last and First name are columns A and B, and phone numbers on the second sheet are columns D, E, and F.