Forum Discussion
Looking for alternate ways for XLOOKUP
While using Excel to maintain a cash flow spreadsheet, I use XLOOKUP to retrieve category and subcategory assignments for both Credit and Debit transactions. This works for 80% of the entries, howev...
=IFNA(INDEX(Transaction[Category],XMATCH(TRUE,ISNUMBER(SEARCH(Transaction[Transaction],B2)))),"Add to lookup")
An alternative could be this formula in cell E2. The corresponding formula is in cell F2 and both formulas are filled down.
- Thanks, Oliver, this works as I wanted!
