THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 50 of 50

Take your time. Find what helps.
Editorial illustration for XLOOKUP an exchange rate by transaction date (nearest earlier date)
Spreadsheets 4 min read

XLOOKUP an exchange rate by transaction date (nearest earlier date)

Use XLOOKUP with match mode -1 to find the exchange rate on or before each transaction date, so weekends and holidays pick up the previous working day rate.

Read article
Editorial illustration for XLOOKUP with a fallback: check your own list, then a general one
Spreadsheets 3 min read

XLOOKUP with a fallback: check your own list, then a general one

Nest one XLOOKUP inside another so your own merchant overrides are checked first, then a default list, then Uncategorised. Worked on five sample merchants.

Read article
Editorial illustration for XLOOKUP returning several columns: category, subcategory, tag
Spreadsheets 3 min read

XLOOKUP returning several columns: category, subcategory, tag

One XLOOKUP over a merchant table can return category, subcategory and tag together, spilling into three cells. See the layout and the two-column variant.

Read article
Editorial illustration for XLOOKUP from the bottom: pull the latest amount paid to a biller
Spreadsheets 3 min read

XLOOKUP from the bottom: pull the latest amount paid to a biller

Use XLOOKUP search_mode -1 to pull the latest electricity bill amount from a long log without sorting, and see the LOOKUP(2,1/...) trick for older Excel.

Read article
Editorial illustration for XLOOKUP with wildcards for partial merchant names
Spreadsheets 4 min read

XLOOKUP with wildcards for partial merchant names

XLOOKUP wildcards for partial merchant names: how match_mode 2 and the asterisk pattern work, and why the lookup direction is reversed for keywords.

Read article
Editorial illustration for XLOOKUP wildcard picks the wrong merchant: how to fix the match
Spreadsheets 3 min read

XLOOKUP wildcard picks the wrong merchant: how to fix the match

Why a short keyword like amazon also matches Amazon Pay Bill in your XLOOKUP merchant list, and how to fix it with specific keywords and a match counter.

Read article
Editorial illustration for Year-end expense summary in Excel: pivot table by month and category
Spreadsheets 4 min read

Year-end expense summary in Excel: pivot table by month and category

Build a year-end expense summary in Excel with a pivot table by month and category, plus a top-merchants pivot, with the matching steps for Google Sheets.

Read article
Editorial illustration for Year-over-year spending by category with % change
Spreadsheets 4 min read

Year-over-year spending by category with % change

Build a year-over-year spending table by category in Excel: last year, this year, rupee change and percent change, with sorting and new categories handled.

Read article
Editorial illustration for Year-to-date expense total in Excel (calendar and fiscal)
Spreadsheets 3 min read

Year-to-date expense total in Excel (calendar and fiscal)

Calculate year-to-date expenses in Excel for the calendar year or the April-March financial year with SUMIFS and TODAY, and build a monthly YTD column.

Read article
Editorial illustration for Zero-based budget in Excel: formulas that check you reach zero
Spreadsheets 4 min read

Zero-based budget in Excel: formulas that check you reach zero

Set up a zero-based budget in Excel with an income cell, category allocations and a Left to allocate formula that turns green at zero and red otherwise.

Read article
Editorial illustration for Zero-based budget template in Excel where every rupee has a job
Spreadsheets 4 min read

Zero-based budget template in Excel where every rupee has a job

Build a zero-based budget template in Excel with income at the top, every category allocated and a Left to assign cell that must reach zero each month.

Read article