I have two sheets in one Google Sheets document:
| Key | Amount | |-----|---------| | ABC | 1 | | DEF | 2 | | GHI | 3 |
| Keys | |-------| | ABC | | XYZ | | JKL | | GHI |
Now, I'd like to add the amounts in the rows of the first sheet but only where the key is contained anywhere in the second sheet. For the example above, the sum would be
ABC with amount
GHI with amount
I've been trying
VLOOKUP but haven't been able to find a solution. Any help would be greatly appreciated!