INDEX APPROXIMATE MATCH OR WILDCARD
I'm trying to have my spreadsheets scan credit card statement transactions and automatically categorize them from an index of tax categories. I listed many keywords that should correspond to each tax category, and set the match to approximate, hoping it would be smart enough to find the keyword nested within the lengthy transaction description, but it seems to fail when my index list is large. The screenshot shows what I mean. Beyond fixing this error, it would also be amazing if I could add a SUMIF or SUMIFS function to calculate the total for each tax category after the index and approximate match functions have automatically categorized the expense. If the latter is not possible, I already have a successful SUMIF function that I could run separately on the INDEX MATCH results
