Forum Discussion
Roshdamunki
Mar 13, 2025Copper Contributor
Cross Reference with variable data
I have to cross reference two worksheets. I have mocked an example below. Sheet 1 lists a Credit card statement. Sheet 2 is an Amazon purchase list. I have to check that the CC data is picked up in t...
Roshdamunki
Mar 19, 2025Copper Contributor
Thank you. I performed this and it gave me good data. My query is for the last SUMPRODUCT formula. If in Sheet 2 column B =Amount and C=Date, why am I creating a Key column for Amazon =D column? It never gets used in your formula?