If the common thing between them is something like an email address or account number, I wonder if the venerable vlookup or the new xlookup will work?
Then I agree with making a new file or sheet and put that common value in one column and remove duplicates. Then use columns B,C,D,E,F, etc to lookup your other data. Be careful about the dollar signs in your cell references. A1 and $A$1 refer to the same cell, but behave differently when you copy and paste. The dollar signs tell Excel to lock that reference in place. Without it, Excel will adjust the reference when you copy and paste it around. I don't think I'm explaining this very well. For sure someone else has done this before. I'd be surprised if Excel couldn't handle it. Andy On Sat, Dec 18, 2021, 12:03 Chuck McCown via AF <[email protected]> wrote: > > I have at least three files I need to merge. Spreadsheets. > > Say one has names and addresses > One has addresses and phone numbers > One has phone numbers and email addresses > > They are not the same length of file so certain records are missing in all > three files. > There is something common to allow one file to be merged into at least one > of the other files. > > I really don’t want to write code to parse and search. > I am hopeful there is some kind of feature in excel that could do this. > Or I guess I might be able to fire up a database and make it happen. > > Any suggestions? > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com >
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
