I have 2 spreadsheets, source and destination. I need to paste the value from source to destination based on Column A and column header, much like a matrix lookup but will not affect the other existing data in the destination unless matches from the source and also will ignore blanks from the source
example
source:
| Column A | Header 1 | Header 2 | Header 3 |
| -------- | -------- | -------- | -------- |
| Pumpkin | | 245 | |
| Apple | | 600 | 500 |
destination:
| Column A | Header 1 | Header 2 | Header 3 |
| -------- | -------- | -------- | -------- |
| Pumpkin | 100 | | 900 |
| Apple | 45 | | |
final output in destination:
| Column A | Header 1 | Header 2 | Header 3 |
| -------- | -------- | -------- | -------- |
| Pumpkin | 100 | 245 | 900 |
| Apple | 45 | 600 | 500 |
EDIT:
This is not similar to this question: copy data from one sheet to another in google app script and append a row, one small issue
in my case, the destination is has data already, and the data from source will just update/add the existing data in the destination spreadsheet, and this can be in the anywhere in the spreadsheet, thus it should look for the specific criteria in column A and in column header. This has been told in the original question already
