Spreadsheet VLOOKUP Function


Spreadsheet VLOOKUP Function

Spreadsheet VLOOKUP Function

Spreadsheet VLOOKUP Function

(Price Catalog Mini Project 3 of 4)

Vertical Lookup, a simple yet powerful function, will supercharge your spreadsheets. Best used with Named Ranges, this function searches vertically through rows of data to find a matching value. Once the matching value is found it then moves a defined number of rows to the right and returns the value it finds there. Simply put, it retrieves values you specify from a range of data. While this function can be used with standard cell ranges, it’s true power is unleashed when used with Named Ranges. Be sure to view part 2 in the series titled Spreadsheet Named Ranges.

Over the years this function dynamo became a foundational tool for my most elaborate spreadsheets. When used in conjunction with logical IF() and the ISERROR() functions, the VLOOKUP() ensures perfect data integrity.

Topics Covered in Spreadsheet VLOOKUP Function:

  • Examination of the four required arguments
  • Standard cell ranges versus named ranges
  • The need for absolute references when using standard cell ranges
  • The importance of selecting the correct cell range (first column requirement)
  • Source data formatting and structure requirements

This video is part of the series titled: Price Catalog Mini Project. This series lays the foundations for the full-scale price catalog project.


About Pete Hahn

For those trying to contact me about our professional services you will find all those details here: https://www.hahn-tech.com/about/ Any questions not related to our professional services or premium indicators should be directed to the comment section of the applicable video or you may post a question in our Q&A Forum: https://www.hahn-tech.com/thinkorswim-forum-topics/

Questions? Comments? Post a review?