Forum Discussion
Merging two tables
I have two tables (One and Two). Table One is the main table which has names in rows and dates in columns. Values are just simple values and some cells are zero.
The other table Two has also the same features but some names are missing, names are not in the same order as in table One and some dates are also missing. There are values in cells and some cells have no values.
I would like to have the table One and add values from the table Two to the corresponding cells in table One IF the date and name are the same.
Some kinda lookup is needed with two IF's... 🙂
Thanx in advance,
-Pasi
6 Replies
Something like in the attached example, using INDEX and MATCH?
EDIT: Attached another file as my first one did not exactly return the requested solution. I believe this one does.
And sorry about the delay in my answer to you; apparently my Edge logs me out after a short while and and I have not received any email nor notifications from your replies...
-Pasi
Uploaded another suggested solution in my original post, after a more careful study of your request and file.
- Can you please upload the (anonymized) Excel file rather than a screen-shot?
Here is the table, don't worry about the names; they are fictious 🙂
The name of table is in Finnish 🙂
