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...
Use
=INDEX(Lookup_Table[Category], MATCH(TRUE, ISNUMBER(SEARCH(Lookup_Table[Transaction], [@Transaction])), 0))
and
=INDEX(Lookup_Table[SubCategory], MATCH(TRUE, ISNUMBER(SEARCH(Lookup_Table[Transaction], [@Transaction])), 0))
HansVogelaar , thanks, that seems to work as I wanted!!