Forum Discussion
rendarcjb
Oct 19, 2019Copper Contributor
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...
Twifoo
Oct 20, 2019Silver Contributor
Try this:
=IFNA(LOOKUP(2,1/(
COUNTIF(C58,”*”&F$52:F$261&”*”)),
G$52:G$261),
“”)
=IFNA(LOOKUP(2,1/(
COUNTIF(C58,”*”&F$52:F$261&”*”)),
G$52:G$261),
“”)
- rendarcjbOct 20, 2019Copper Contributor
Twifoo thank you for your help! However, I'm getting a parse error
Maybe let's start with just having it automatically categorize and forget about the summation part.
- SergeiBaklanOct 20, 2019Diamond Contributor
Are you on Excel or Google Sheets? It looks like the latest and it can't parse the formula.
- rendarcjbOct 20, 2019Copper Contributor
SergeiBaklan google sheets. I'm sorry, I should have realized this could be incompatible with google sheets.
Anyone have suggestion for how to do this in google sheets? I won't post any more questions about google sheets