Vlookups and Hlookups

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
Lookups are the next level tool for users. Along with the Index function, lookups are very powerful tools in Excel which allow us to locate as well as extract very specific data in large and complex sets of data. Here’s an example. Imagine you have a table that is 1000 by 1000 cells in size. Your name is buried somewhere in that table in a random location. To look for it manually would take some time. You could use the Excel search function but that would mean you’d have to do it every time and can’t exactly be automated or linked to any cells in your spreadsheet. However, with the lookup function, we can write the code once and it can locate for us in the blink of an eye. It doesn’t even matter if it changes position, it will keep looking for your name. 

TARGET AUDIENCE
For those looking to automate there tables or those who have dynamic tables with consistently changing data

STRUCTURE
This is a rather short course with about 15 videos and a time just over 30 minutes. 

DIFFICULTY
This is more for advanced users

COURSE OUTCOMES

  • Basic code structure
  • True and false conditions
  • Column to column relations
  • Error handling
  • Table to table combinations
  • Search engine design
  • If function combination
  • Data validation

Course Structure

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.