---
title: "Discussion on \"VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch\" | Hashnode"
description: "Discussion on \"VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch\". By the end of this page you can write both lookup formulas, read either one in someone else's workbook, and pick between them on purpose. You will know the three specific ways VLOOKUP returns a wrong"
url: "https://hashnode.com/posts/vlookup-vs-xlookup-which-one-to-use-and-how-to-switch/6a7ca03ed842dc273dd0cca2"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch](https://michaelnocito.hashnode.dev/vlookup-vs-xlookup-which-one-to-use-and-how-to-switch?utm_source=hashnode&utm_medium=feed)

By the end of this page you can write both lookup formulas, read either one in someone else's workbook, and pick between them on purpose. You will know the three specific ways VLOOKUP returns a wrong

Aug 12 · 17 min read · michaelnocito.hashnode.dev  
Read the article

-   [#excel](https://hashnode.com/tag/excel)
-   [#data-analysis](https://hashnode.com/tag/data-analysis)
-   [#beginners](https://hashnode.com/tag/beginners)

## Written by

[Michael Nocito](https://hashnode.com/@michaelnocito)

@michaelnocito · Glassboro, New Jersey

  
[View profile](https://hashnode.com/@michaelnocito)

Data analyst who builds things that teach: browser tools, games, and real data projects.

Data analyst with eight years migrating enterprise contract data. I build browser-based learning tools for analysts, games that teach real skills, and portfolio projects on real datasets. Interested in the science of how people actually learn, and in charcoal portraits, mostly of dogs.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.