Topics

  • AI Tools (2)
  • AutoHotkey (1)
  • Automation (3)
  • Build Your Own LLM (5)
  • Charts & Dashboards (2)
  • Deep Learning (1)
  • Essbase (3)
  • Excel Formulas (11)
  • Excel VBA (104)
  • Formula Combos (5)
  • Fun Facts (8)
  • Google Workspace (1)
  • History (3)
  • Internet & Browser (2)
  • Java (2)
  • JavaScript (2)
  • LLMs (4)
  • Machine Learning (5)
  • Office Scripts (1)
  • Oracle EPM Cloud (1)
  • Oracle Smart View (3)
  • Outlook (4)
  • Phone (2)
  • Power Automate (2)
  • Power Query & Pivots (3)
  • PowerPoint (3)
  • PowerShell (1)
  • Productivity (3)
  • Prompt Engineering (1)
  • Python (4)
  • Python Automation (2)
  • R (2)
  • RAG & Agents (2)
  • Rust (1)
  • SAP (6)
  • SAP GUI Scripting (3)
  • Science (3)
  • Security & Privacy (2)
  • SQL (3)
  • Tech Tips (1)
  • Windows (3)
  • Word (3)

Recent posts

  • Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
  • 5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
  • SAP SE16N and SQVI: Pull Table Data Without ABAP
  • Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
  • LET and LAMBDA: Write Your Own Excel Functions (No VBA)
  • Why Do We Have Leap Years? (And Why 1900 Was Not One)

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips — plus wacky facts

Menu

Skip to content
  • Excel
    • Charts & Dashboards
    • Excel Formulas
    • Excel VBA
    • Formula Combos
    • Power Query & Pivots
    • Excel VBA Course
  • Office
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
  • AI & ML
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • RAG & Agents
    • Build Your Own LLM Course
  • SAP & Oracle
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
  • Automation
    • AutoHotkey
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • Tech Tips
    • Internet & Browser
    • Phone
    • Productivity
    • Security & Privacy
    • Windows
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • VBA Playground
    • Formula Lab
    • VBA Bug Hunt
    • Macro Recorder
    • SQL Playground
    • Date & Workday Calculator
    • Excel Shortcut Trainer
    • VBA Quiz
    • Formula Explainer
    • EMI & SIP Calculator
    • Regex Tester
    • CSV to SQL Converter
    • VBA Code Formatter
    • Office Shortcut Finder
  • About
  • Projects

Formula Lab: VLOOKUP vs XLOOKUP vs INDEX-MATCH

Pick a lookup value and watch how each formula searches the table. Switch to “look left” mode to see why VLOOKUP fails where XLOOKUP and INDEX-MATCH succeed.

More free tools

⚡VBA PlaygroundStep through macros line by line on a live mini-sheet.🐞VBA Bug HuntSpot the broken line in real-world macros. How many can you fix?🔴Macro RecorderClick and type on a grid — get the VBA code instantly.
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →