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.