Excel merging data or lookup
Posted on 2009-02-09
I have 2 spreadsheets that I need to "grab" data from one of them in to the other.
One spreadsheet (1) has contacts with their addresses (8 columns: A = Name, B = Company, C = Street Address, D = Street Address 2, E = City, F = State, G = Zip, H = Country)
The other spreadsheet (2) has contacts with the number of shares. (2 columns: A = Name, B = Shares)
The Names in the spreadsheets may not be identical, but they are similar. Is there a way to pull with an "If" statement where Spreadsheet (1).Name is LIKE Spreadsheet (2).Name... And there will be some Names in one spreadsheet and not the other (this goes both ways).
Is there any way to "grab" the address info from spreadsheet (1) and place in spreadsheet (2)?
I have tried vlookup, but it was pulling incorrect data. Looked as if it was only grabbing the first instance of the first name and not matching according to the full name.
Hope that makes sense! Thanks!