Cloud Wars
  • Home
  • Top 10
  • CW Minute
  • CW Podcast
  • Categories
    • AI and Copilots
    • Innovation & Leadership
    • Cybersecurity
    • Data
  • Member Resources
    • Cloud Wars AI Agent
    • Digital Summits
    • Guidebooks
    • Reports
  • About Us
    • Our Story
    • Tech Analysts
    • Marketing Services
  • Summit NA
  • Dynamics Communities
  • Ask Copilot
Twitter Instagram
  • Summit NA
  • Dynamics Communities
  • AI Copilot Summit NA
  • Ask Cloud Wars
Twitter LinkedIn
Cloud Wars
  • Home
  • Top 10
  • CW Minute
  • CW Podcast
  • Categories
    • AI and CopilotsWelcome to the Acceleration Economy AI Index, a weekly segment where we cover the most important recent news in AI innovation, funding, and solutions in under 10 minutes. Our goal is to get you up to speed – the same speed AI innovation is taking place nowadays – and prepare you for that upcoming customer call, board meeting, or conversation with your colleague.
    • Innovation & Leadership
    • CybersecurityThe practice of defending computers, servers, mobile devices, electronic systems, networks, and data from malicious attacks.
    • Data
  • Member Resources
    • Cloud Wars AI Agent
    • Digital Summits
    • Guidebooks
    • Reports
  • About Us
    • Our Story
    • Tech Analysts
    • Marketing Services
    • Login / Register
Cloud Wars
    • Login / Register
Home » Learn How to VLOOKUP in Excel with a Practical Example
Cybersecurity

Learn How to VLOOKUP in Excel with a Practical Example

Keith SayerBy Keith SayerJanuary 5, 20215 Mins Read
Facebook Twitter LinkedIn Email
Share
Facebook Twitter LinkedIn Email

By Keith Sayer, May 27, 2020

Have you heard about the benefits of the VLOOKUP function in Excel but are having trouble getting started? In this blog, I share how using a practical example and providing an example file so you can follow along!

The Setup for Our Example

In this example, we are imagining that we have a list of contacts, perhaps a registration list for a webinar or people who clicked an ad. Our objective is to distribute these contacts to our sales team for followup, but we need to make sure each salesperson only gets the contacts for companies they manage.

That’s where our second spreadsheet comes in. We pulled it from our CRM system, and it includes basic information about each company, including its assigned account manager. Now we could go line by line and copy-paste the Account Manager for each company to each contact, but that’s time-consuming! In reality, each spreadsheet could have hundreds or thousands of entries. Instead, let’s use VLOOKUP to help.

As a preliminary step, I have opened the Contacts spreadsheet and added a New Sheet at the bottom of our workbook where I copy-pasted the entire Companies export I received from my CRM. I have created new columns that I want to fill in: Column G for Owner (where I want the Account Manager’s name to appear) and Column E for Industry (where I want to see the industry name for each contact’s company).

You can download the XLSX file I used for this example so you can follow along.

Download the File

Step-by-Step Instructions for the VLOOKUP Function

If you would like to go through a guided ClickLearn exercise, click the link below. 

Follow the Demo

Note: To advance the demo, you need to actually click where directed.

Otherwise, continue below to see each step in the process.

  1. Click on the cell G2 under the Owner column.
  2. cl2
  3. Enter the text =vlookup(
  4. cl3
  5. Click on the cell D2 with the value ABC Corp. This adds the reference to column D, where we have the company name for each contact, to our formula. We will use this value to match with a company record.
  6. cl4
  7. Press “,” (comma)
  8. Click on the tab Companies.
  9. cl6
  10. Click and hold the left mouse button on the column header A
  11. Release the left mouse button on the column header E. By selecting these columns, we have effectively selected all the data in this table. Note that it is very important that the value you are looking up (in this case the Company Name) be to the left of the item you want to return (in this case, the Account Manager).
  12. cl8
  13. Enter the text ,3,false). Press Enter and you will be taken back to the Contacts sheet. (3 refers to the column number of the data you want to be returned. In this case, we want the Account Manager, which is in the 3rd column. False refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out “False.”)
  14. Click on the right part of the cell G2 with the value Todd White
  15. cl10
  16. Double click on the right part of the cell G2 with the value Todd White. This pastes the formula of our first row into all subsequent rows.
  17. cl11
  18. Now let’s try this on the Industry column. The process is exactly the same. Click on the cell E2.
  19. Enter the text =vlookup(
  20. cl13
  21. Click on the cell D2 with the value ABC Corp
  22. Press “,” (comma)
  23. Click on the tab Companies.
  24. Click and hold the left mouse button on the column header A
  25. Release the left mouse button on the column header E
  26. Enter the text ,5,false). Press the Enter key. (5 refers to the column number of the data you want to be returned. In this case, we want the industry of the company to come back, which is in the 5th column. False refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out “False.”)
  27. cl20
  28. Click on the cell E2 with the value Media
  29. Double click on the right part of the cell E2 with the value Media.

You can repeat this process as many times as you like to combine spreadsheets as your business process requires.

Conclusion

I hope you are already thinking of how you can use this function to manage data more efficiently in your work. It allows you to collate different spreadsheets to find the information you need to submit reports or run other functions. For example, you could take an export of data from Business Central or NAV and combine it with a spreadsheet from another program you use. Then use VLOOKUPs to make the connections.

VLOOKUP is only one of the many powerful data management tools available to you in Microsoft Excel. To learn more about what you can do with this product, consider checking out all of the Innovia blogs on this topic. Or if you want to know how to get Excel for your business, review the Microsoft 365 packages we offer at Innovia.

Dynamics 365 CE / CRM Dynamics Business Central / NAV
Share. Facebook Twitter LinkedIn Email
Keith Sayer

I am a communications and multimedia marketing specialist. A writer at heart, I enjoy the challenge of producing high quality copy that communicates concisely and persuasively with potential customers. I have experience designing websites with several CMS systems, developing social media and online content strategies, using CRM-based marketing automation to create comprehensive digital marketing strategies, and producing video for corporate marketing and entertainment purposes.

Related Posts

AI Agent & Copilot Podcast: Security, Microsoft Copilot Partnership Insights from Zenity’s Michael Bargury

June 4, 2025

AI Agent & Copilot Podcast: St. Luke’s University Health Network On Expanding AI Use Cases

May 20, 2025

Apps Apocalypse: Bill McDermott Joins Satya Nadella in Saying AI Agents Will Crush Applications

May 12, 2025

Bill McDermott Channels Satya Nadella: AI Agents Will Turn Apps Into CRUD

May 12, 2025
Add A Comment

Comments are closed.

Recent Posts
  • Oracle Will Leapfrog Google Cloud as World’s #1 Hottest Cloud Vendor
  • Data, Governance & Infrastructure: Key Takeaways from Marine Corps AI Strategy
  • Can Oracle Overtake Google Cloud as #1 Fastest-Growing Vendor?
  • Slow-Walking AI Hazardous to CEO Health, Warns OpenAI CEO Sam Altman
  • OpenAI’s Sam Altman: CEOs Must Move Fast to Win in the AI Era

  • Ask Cloud Wars AI Agent
  • Tech Guidebooks
  • Industry Reports
  • Newsletters

Join Today

Most Popular Guidebooks

Accelerating GenAI Impact: From POC to Production Success

November 1, 2024

ExFlow from SignUp Software: Streamlining Dynamics 365 Finance & Operations and Business Central with AP Automation

September 10, 2024

Delivering on the Promise of Multicloud | How to Realize Multicloud’s Full Potential While Addressing Challenges

July 19, 2024

Zero Trust Network Access | A CISO Guidebook

February 1, 2024

Advertisement
Cloud Wars
Twitter LinkedIn
  • Home
  • About Us
  • Privacy Policy
  • Get In Touch
  • Marketing Services
  • Do not sell my information
© 2025 Cloud Wars.

Type above and press Enter to search. Press Esc to cancel.

  • Login
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.