From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

VLOOKUP pros and cons

VLOOKUP pros and cons - Microsoft Excel Tutorial

From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Start my 1-month free trial Buy for my team

VLOOKUP pros and cons

“

- We just used our first lookup function, and you may be thinking, you got what you need. Why take the rest of this course? Well, as you'll see with each of our lookup functions, there are pros and cons of each, and you may opt for another lookup function, overview lookup, especially once you learn about all of it shortcomings. Okay, before we start ripping on the OG VLOOKUP, let's discuss why it's so great. The reason number one is, well, it's just really widely known. Almost everyone knows what a VLOOKUP function is, because it's been around for so long. Now, I'm not sure if it's being taught in classrooms or in the workspace, but somehow everyone starts off with a VLOOKUP. It may be because it's so simple. Our syntax was a breeze. All we needed was our lookup value, range, column index, and match type. You can open up a spreadsheet, use a quick VLOOKUP, send the file over to your boss, and make it home before supper time. But although it may be the most popular lookup function, to…

Contents