Why VLOOKUP returns #N/A or #REF!
A safe way to check missing lookup matches, invalid return columns, invisible spaces and data types before changing the workbook.
Fix Excel lookup errors →Resources
Practical guides to help you understand the problem, make a clearer digital decision and choose the right next step for your business.
Studio library
Clear, useful thinking for decisions that businesses often overcomplicate.
A safe way to check missing lookup matches, invalid return columns, invisible spaces and data types before changing the workbook.
Fix Excel lookup errors →Check delimiters, leading zeros, dates, duplicate rows and validation before trusting an imported file.
Read the CSV cleaning guide →A practical nine-point check for scope, evidence, price, deliverables, exclusions and acceptance.
Read the proposal checklist →A practical checklist for structure, mobile usability, speed, accessibility, security, trust and measurement.
Read the website essentials checklist →A practical homepage structure for clearer messaging, stronger trust and an obvious next step.
Read the homepage checklist →Use the dedicated directory to find private browser-based tools for meetings, documents, spreadsheets, SOPs, decisions and workflow planning. No signup or file upload is required.
Browse all free business tools →Where AI can genuinely save work, where human judgement still matters and how to keep the tool in its proper place.
See where AI fits →Make the real problem, desired outcome and useful existing assets visible before the solution is chosen.
Build a better brief →Compare the evidence, alternatives and constraints, then make the next step clear.
Explore research and decision support →Pressure-test buyer fit, alternatives, pricing and the smallest useful version before committing time or budget.
Explore the Decision Pack →Improve the structure and clarity of an existing report, proposal or guide, with an editable handover.
See Document Finish →