Forum Discussion
Merge two tables using formulas only
Rajesh_Sinha I have a similar issue, but with an added wrinkle or two. The examples posted seem like they might do the job, but I want to merge info from 2 tables that have different columns, and which also may have repeated names in one column in one table, but not the other.
The only shared column will be Name. And in the main table, there will be no double ups, as it's a running list of "clients." The second table is a list of interactions with clients, so they may appear more than once. The second list has no reference to their basic info. Age/DOB, and other things which don't change, I'd like to be able to add that.
I'll attach a very simplified example spreadsheet to give the idea. Any help appreciated.
Check the attached Sheet, I've solved using Yellow Cells headers,,, read the instruction,, confirm whether is working or not,, in case of queries please share expected output with me!
- Thanks for this. It's been decided by higher ups that the other list can be static now, but I have another sheet this may be useful for. Will definitely check it.