1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Return value based on word found in string of text in a cell?

Our take

If you're looking to streamline your budgeting process in spreadsheets, automating expense categorization is a great step forward. With your current setup, you're using XLOOKUP to match vendor names with keywords in Column H. However, the formula may need adjustment to effectively return the desired category. Instead of relying solely on XLOOKUP, you might consider using a combination of SEARCH and INDEX functions for more flexibility. This approach can simplify the matching process, making it easier to categorize transactions accurately and efficiently.

I am building a spreadsheet to help budget some expenses and am trying to automate as much as I can. I have a table in Column H with a keyword like "Gas" or "Electric" and then a corresponding category in Column I that groups this into something like "utilities".

I have a spreadsheet where I export my bank statement and Column B is the vendor and Column C is the amt. I have Column D trying to group all the expenses based on the helper table in Columns H and I to quick and easy organize all the transactions for a month.

I made the formula: =IFERROR(XLOOKUP(B3,ISNUMBER(SEARCH($H$3:$H$35,B2)),I:I),"Uncategorized") to try and get a return and it doesn't work just yet. I feel like I'm close but I'm not as familiar with XLOOKUP as I want and I cant figure out what I could use to make return any easier. Is there a simpler way to get a return like this from a string of text or am I missing something with how the XLOOKUP works?

submitted by /u/Pmme10doller_psncard
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#cloud-based spreadsheet applications#financial modeling with spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#Excel alternatives for data analysis#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#rows.com#natural language processing for spreadsheets#AI formula generation techniques#generative AI for data analysis#Excel compatibility#formula generator#Excel alternatives