How to vLookup in Excel

How to vLookup in Excel

VLOOKUPS When Using Excel: It’s Time to Take the Plunge

This is an intervention. You’ve been proclaiming yourself an Excel user without having proficiency in VLOOKUPS. For shame!

 

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.

How To Use Vlookups - InvestinU

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.

Huh?

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.

What else?

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

Follow us on YouTube Facebook, LinkedIn, and Insta to hear about more upcoming webinars, and you’ll be mastering the universe in no time. Or, at least, mastering your computer.

Get in touch to hear more about training, support, branding, web design, and more. At InvestinU we take the complicated and make it simple.

*Haha

Jul 24, 2013

Eoin Lynch
How To Use Vlookups

   About InvestinU

   In the Media

   Testimonials

  Training

   Bespoke Online Webinars

   Expert Advisory Sessions

   Microsoft 365 Support

   Customised Training

   One-to-one Consultancy

   Bite-Size Learning

   Design

   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design

   Web

   E-commerce Websites

   Brochure Websites

   SEO

   Social Media Management

   Content Creation (Blog)

    Development

   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Invest365 Microsoft Webinars

   Invest365 Microsoft Support

   Expert Advisory Sessions

   Invest365 Microsoft Ultimate