I am looking to assess our spending by categorising our bank statement, line by line.

I'm using a VLOOKUP with wildcards. For reasons I cannot understand, this wildcard lookup is not working. It only works if the text in column "Description" matches an item from the lookup array exactly.

why does my formula in G2 not correctly wildcard match one of the values in the lookup array?

CodePudding user response：

If you an user of Microsoft 365 then try-

=@FILTER(H4:H6,ISNUMBER(SEARCH(G4:G6,C2)))