How to vLookup in Excel
How to vLookup in Excel
VLOOKUPS When Using Excel: It’s Time to Take the Plunge
Now, any self-respecting Excel user knows that there is an array of formulas, but the VLOOKUP is an essential tool when searching for data.
But, no, not you. you click away, day after day, searching for the data, headache brewing. You could be done by now, feet up, but you insist on doing things the old-fashioned way. You’re doing the Microsoft Excel equivalent of cutting the lawn with scissors when there’s a shiny new ride-on lawnmower in the garage. Oh, you.
Well, enough is enough. It’s time for some tough love, people.
What is a VLOOKUP?
Never heard of it? Don’t worry, no one is laughing at you*. The vertical lookup, or VLOOKUP as the cool kids say, is a popular function that’s used when you want to pull information from a table. It makes Excel search for a certain value in a column (the table array) in order to return a value from a different column in the same row.
Stick with us, all will become clear.
What can it do?
Um, it can change your life. Well, your work life. It’s a game-changer for any Excel user that needs to manipulate data since it can find information in a large spreadsheet. You know, like searching for brain cells among Love Island contestants. Very useful if you search for the same kind of data often.
Let’s take an example. VLOOKUPS are like the phone book you used to stalk your crush in the 90s. You start with the piece of data you know, which is the name, in order to find out what you don’t know, their number.
Well, it helps you to create LOOKUP tables in Excel that can map one value to another – so if you know a client’s country, you can figure out their currency with a two-column table. Alternatively, you can look up products and find out prices.
Now we’re talking.
Why do we need it?
The VLOOKUP saves you time, energy, and nerves. It’s easy to use, and more accurate than manually looking things up, so there’s less human error.
I mean, if time-saving and efficiency are important to you.
Sixty minutes to change your work life
Want to master the power of VLOOKUPS but don’t have a lot of time? Register for our FREE WEBINAR on 28th July at 12.30 – see the pros in action, learn a few tips and tricks, and enjoy a fast-paced learning environment at zero cost.
The webinar will cover:
-what is a VLOOKUP?
– how does it work?
– Different types: V versus H
– LOOKUPS & tables