FinanceTier 415 minintermediate

Look Up an Account Balance

Look up an account balance from a chart of accounts using a lookup formula that stays correct when copied down.

What you will learn

• Write a lookup formula with the table range locked so it does not shift when copied
• Explain why an unlocked table reference silently breaks every row after the first
• Choose a lookup approach that works regardless of column order

Excel skills

VLOOKUP, XLOOKUP · Lookups

The task

Look up each requested account's balance from the Accounts sheet. In B2, write a lookup formula with the table range locked, so it still points at the full table when copied down to B3 and B4.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free