Spreadsheet Functions
VLOOKUP
Definition
A lookup function that searches the first column of a range for a key and returns the value of a specified cell in the row found. VLOOKUP stands for "vertical lookup" because it searches down the first column of a table. In Google Sheets, the syntax is =VLOOKUP(search_key, range, index, [is_sorted]). While still widely used, INDEX-MATCH is generally preferred for its flexibility since VLOOKUP can only search left to right.
Related Templates
These SheetCraft templates use or relate to VLOOKUP:
- Small Business Bookkeeping System, Simple bookkeeping for small business owners who don't have an accountant, income, expenses, P&L, sales tax, and bank reconciliation.
- Freelancer Financial Hub, All-in-one financial management for freelancers, income tracking, expense categorization, quarterly tax estimates, and client profitability.