Forum Discussion

Copper Contributor

Oct 19, 2019

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...

INDEX FUZZY MATCH

Twifoo

Silver Contributor

Oct 20, 2019

Try this:
=IFNA(LOOKUP(2,1/(
COUNTIF(C58,”*”&F$52:F$261&”*”)),
G$52:G$261),
“”)

rendarcjb
Copper Contributor
Oct 20, 2019
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.
- SergeiBaklan
  Diamond Contributor
  Oct 20, 2019
  rendarcjb
  
  Are you on Excel or Google Sheets? It looks like the latest and it can't parse the formula.
  - rendarcjb
    Copper Contributor
    Oct 20, 2019
    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