srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
I need to match two tables of data. On table one, on column A I have GL numbers like 50010020 etc. and on another table, I have the same numbers, in the same columns (I have arranged the two pivot tables to compare), I need to match column A, where the same GL number appears multiple times and the corresponding value/text in column B are different, like MVNO Sales tax, or MVNO Telephone Sales Tax. Table 2 has the same data except before MVNO Sales Tax, there are 4 letters that are not in table one. I need to compare the total of each category in the two pivot tables.
Therefore I need the formula that lookup matching values from column A (SUMIFS, or SUMPRODUCT) and match the second text from column B removing the four characters (maybe mid(), function) and sum the values from table,
Please advise.
Therefore I need the formula that lookup matching values from column A (SUMIFS, or SUMPRODUCT) and match the second text from column B removing the four characters (maybe mid(), function) and sum the values from table,
Please advise.