Log In
Register
Home
New Member
September 23, 2022
Offline
in the attached spreadsheet I got my issue also explained.
in tab transactions, colums a, b, e & H, i get from my bank downloads.
in column F, i got the formula, this formula looks at the description (H) and also to tab categories, cell D1, D1 describes a range of words and corresponding categories, it looks at words in the description.
QUESTION
I can't get the formula to work, in transactions, column F (step 2,1 above),
the formula to regocnise keywords in the description, defined in categories. which are on tab Categories.
Working example (in tab Transactions2): in tab Transactions 2 i got it to work, but not how i want it.
What I want is
the formula in tab Transactions column F to work properly, like the formula in Trasactions 2 column K.
in the transactions tab there's only space available for TBL_Transactions1.
the table TBL_Keywords devined in tab categories
You get it? can you help me out, please?
(I got Office365 and Windows 10)
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Hi Koen,
I used the following formula in F2 on the transactions sheet:
=LOOKUP(1,XMATCH("*"&TBL_Keywords1[Keyword]&"*",[@Description],2),TBL_Keywords1[Category])
I copied the more complete Category list from Transactions2 (and entered a few myself), so that there were more matching entries. And you'll see that I'm using structured table references, the avoiding OFFSET and INDIRECT.
Not sure how this formula translates to Dutch Excel, which I assume you are using. But if you spend the attached file it should work directly for you.
Riny
New Member
September 23, 2022
Offline
Dear Riny,
thank you so much for the quick response! and solution !
I will study your change / proposal this weekend. First impression is that it works
Thank you again
Greetings from The Netherlands
1 Guest(s)
