• For Individuals
  • For Businesses
  • For Universities
  • For Governments
Coursera
  • Online Degrees
  • Careers
  • Log In
  • Join for Free
    Coursera
    Chevron Left
    Back to Grab Data Fast with Vertical and Horizontal LOOKUP

    Learner Reviews & Feedback for Grab Data Fast with Vertical and Horizontal LOOKUP by Coursera Project Network

    Filled StarFilled StarFilled StarFilled StarStar
    3.8
    stars
    70 ratings

    About the Course

    Data can come our way in multiple forms and from multiple file types. It’s likely that at some point you will be faced with a data set that
    includes categories and subcategories under one heading or under headings with nested subheadings. Cutting through the file structure can
    seem like a time-consuming task, so it is critical to leverage VLOOKUP and HLOOKUP to pull out the needed data quickly. In this course you will
    understand how lookup tables work and apply VLOOKUP and HLOOKUP formulas to quickly extract data by treating a section of your
    spreadsheet as a lookup table. You will do this as we work side-by-side in the free-to-use software Google Sheets. By the end...
    ...

    Top reviews

    Filter by:

    1 - 15 of 15 Reviews for Grab Data Fast with Vertical and Horizontal LOOKUP

    Filled StarFilled StarStarStarStar

    By Nathan P

    •

    May 12, 2023

    This course did an okay job of explaining the LOOKUP functions, but the projects felt like plug-and-play rather than really understanding the process at work. Also, the formulas produced errors on my end, even after I double-checked and even triple-checked to make sure everything was correct.

    Filled StarStarStarStarStar

    By Chen-Wei T

    •

    Aug 12, 2023

    Your long ass formula in the video: =if(vlookup(F2,F2:P55792,1,false)="Nintendo","Nintendo","Other Publisher") & " shipped " & vlookup("Nintendo",F2:P55792,5,false) & " millions units of " & vlookup(2,A2:P55792,2,false) was wrong! You missed the "a" in the last vlookup. You wasted my afternoon. Also, you did not say why you are writing this formula. Please revise this entire course.

    Filled StarStarStarStarStar

    By Dryw F

    •

    Oct 29, 2023

    This course started out overly simplistic, taking 5 minutes to explain how to open a google sheet. There was a small amount of instruction that was helpful and at a good challenge level, with a reasonably complete explanation of how to enter a VLOOKUP formula. The project then jumped to an advanced formula without any explanation. The only direction was to copy the formula, which contained a lot of elements that were never explained. I was making some kind of error in copying the formula, but I wasn't able to correct it because I was just copying with no comprehension of what I was doing. I dropped the course and will look for a different way to learn the content.

    Filled StarFilled StarFilled StarStarStar

    By Jacob N I

    •

    Nov 3, 2020

    Course content had some insufficiency or errors. It needs to be improved, especially the 4th demo video involving VLOOKUP application. The quiz also needs to be improved, in terms of clarity of the questions and ambiguity of the choices.

    Filled StarStarStarStarStar

    By Christopher J

    •

    May 2, 2024

    The class does not match what I'm seeing on my screen, and in the first lesson, the extremely long function in cell T2 does not work. I've tried over and over to get it to work and no luck.

    Filled StarFilled StarFilled StarFilled StarFilled Star

    By Muhammad A K

    •

    Sep 5, 2021

    It's easily to understanding about VLOOKUP and HLOOKUP but get more project with simple data to get more understanding with this skill.

    Filled StarFilled StarFilled StarFilled StarFilled Star

    By LILIANA P

    •

    Mar 13, 2023

    EXCELENTE, BUENA EXPLICACION, TANTO VERBAL COMO VISUAL

    Filled StarFilled StarFilled StarFilled StarFilled Star

    By zenaida a

    •

    Nov 15, 2020

    Recommended course for everyone. Very useful.

    Filled StarFilled StarFilled StarFilled StarFilled Star

    By Belinda N

    •

    Jun 18, 2022

    Very informative and implementable.

    Filled StarFilled StarFilled StarFilled StarFilled Star

    By Sonal P

    •

    Apr 20, 2022

    overall great experience...

    Filled StarFilled StarFilled StarFilled StarFilled Star

    By Ana L

    •

    Apr 4, 2021

    great

    Filled StarFilled StarFilled StarStarStar

    By Kristen A

    •

    Mar 23, 2023

    The project could be more in-depth and cover troubleshooting mistakes/error messages. The instructor was very engaging.

    Filled StarFilled StarStarStarStar

    By David S

    •

    Mar 12, 2025

    Google Sheets does not merge well into the side-by-side lab compared to Microsoft Onedrive. There's no option to full-screen your own workspace from what I saw, and you apparently need a separate plug-in to do basic operations like copy-paste cell contents, which I could not do at the time. The instruction of copying the really long vlookup formula is prone to errors. I only was able to modify it to output the desired result with prior, more advanced knowledge I learned elsewhere. That long formula by itself deserves its own lesson plan for a full breakdown, and feels out of place when sandwiched by simpler vlookup/hlookup formulas. I wanted to learn more about the website she mentioned during the lesson, but she only mentioned it by name without spelling out its URL so I could navigate to it myself. I was only able to navigate to the site the next day through trial-and-error (the site is kaggle.com; at first I heard "Kaygo" so I tried spelling around that). The post-lesson quiz's questions also have some ambiguous wording, so I wound up not passing it first try. The lesson overall had a weird pace. Too much time was spent on the lecture part, that time could've instead gone toward improving the instruction with the really long formula (or replacing it with a simpler example to follow). Not a terrible vloookup/hlookup lesson, but not my first recommendation for learning these functions either.

    Filled StarFilled StarStarStarStar

    By Siddharth A

    •

    May 9, 2024

    Good explanation of "What the function is" but not "How its applied" and used, also its we are just told to directly copy paste the formula, but the formula given for the vlookup is wrong in the video...

    Filled StarStarStarStarStar

    By Syed M R A S

    •

    Apr 17, 2024

    Not working properly

    • Chevron Left
    • 1
    • Chevron Right

    Coursera Footer

    Technical Skills

    • ChatGPT
    • Coding
    • Computer Science
    • Cybersecurity
    • DevOps
    • Ethical Hacking
    • Generative AI
    • Java Programming
    • Python
    • Web Development

    Analytical Skills

    • Artificial Intelligence
    • Big Data
    • Business Analysis
    • Data Analytics
    • Data Science
    • Financial Modeling
    • Machine Learning
    • Microsoft Excel
    • Microsoft Power BI
    • SQL

    Business Skills

    • Accounting
    • Digital Marketing
    • E-commerce
    • Finance
    • Google
    • Graphic Design
    • IBM
    • Marketing
    • Project Management
    • Social Media Marketing

    Career Resources

    • Essential IT Certifications
    • High-Income Skills to Learn
    • How to Get a PMP Certification
    • How to Learn Artificial Intelligence
    • Popular Cybersecurity Certifications
    • Popular Data Analytics Certifications
    • What Does a Data Analyst Do?
    • Career Development Resources
    • Career Aptitude Test
    • Share your Coursera Learning Story

    Coursera

    • About
    • What We Offer
    • Leadership
    • Careers
    • Catalog
    • Coursera Plus
    • Professional Certificates
    • MasterTrack® Certificates
    • Degrees
    • For Enterprise
    • For Government
    • For Campus
    • Become a Partner
    • Social Impact
    • Free Courses
    • ECTS Credit Recommendations

    Community

    • Learners
    • Partners
    • Beta Testers
    • Blog
    • The Coursera Podcast
    • Tech Blog
    • Teaching Center

    More

    • Press
    • Investors
    • Terms
    • Privacy
    • Help
    • Accessibility
    • Contact
    • Articles
    • Directory
    • Affiliates
    • Modern Slavery Statement
    • Manage Cookie Preferences
    Learn Anywhere
    Download on the App Store
    Get it on Google Play
    Logo of Certified B Corporation
    © 2025 Coursera Inc. All rights reserved.
    • Coursera Facebook
    • Coursera Linkedin
    • Coursera Twitter
    • Coursera YouTube
    • Coursera Instagram
    • Coursera TikTok
    Coursera

    Sign up

    Learn on your own time from top universities and businesses.

    ​
    ​
    Between 8 and 72 characters
    Your password is hidden
    ​

    or

    Already on Coursera?


    I accept Coursera's Terms of Use and Privacy Notice. Having trouble logging in? Learner help center

    This site is protected by reCAPTCHA Enterprise and the Google Privacy Policy and Terms of Service apply.