DARREN TROFIMCZUK
  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact

VLOOKUP Function

Using VLOOKUP is similar to looking up a person’s name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.

* VLookUp can only be used with vertical tables (data arranged in columns)

Picture
Picture
Objectives
  • Enter VLOOKUP arguments in a formula.
  • Use VLOOKUP to find values in Excel lists or tables.
  • Avoid VLOOKUP errors.
​
Support Link & Video Examples: 
https://support.office.com/en-nz/article/VLOOKUP-What-it-is-and-when-to-use-it-5984e27b-4f0d-431e-83b1-7ab062c75493

Video Spreadhseet File: 
class_presentation_example.xlsx
File Size: 38 kb
File Type: xlsx
Download File

Absolute Cell Reference: Support Information

Class Task 1 Files

vlookup-excel_task.pdf
File Size: 717 kb
File Type: pdf
Download File

vlookup-example_1.xls
File Size: 23 kb
File Type: xls
Download File


Task 2 File (Example File)

vlookupexample2.xlsx
File Size: 12 kb
File Type: xlsx
Download File

  • Home
  • Publications
  • MY COURSES
    • Artificial Intelligence
    • HTML
    • Python
    • Excel Basics >
      • Cell References
      • Charts & Filtering
      • Basic Functions
      • Filtering
      • VLookUp
      • Pivot Tables
      • HLookUp
      • SumIF & SumIFS
    • Online Analytics & SEO >
      • PowerBI Desktop / Analytics
    • Project Management Tools
    • Digital Footprint
    • CRM-Hubspot & Dynamics
  • CV
  • Contact