Excel VLOOKUP for Beginners: Exact and Approximate Matches

Excel VLOOKUP helps you find a value in a table and return related information from the same row. In this recorded lesson, I work through customer and order records, a score-to-grade table, and an approximate-match practice example. The key is choosing the right match setting for the job.

Watch the VLOOKUP lesson

Watch Excel VLOOKUP for Beginners with Tom Fragale on YouTube.

Understand the four parts of VLOOKUP

The basic structure is =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup).

  • Lookup value: the item you want to find, such as a customer ID.
  • Table array: the range containing the lookup column and the information you want to return. VLOOKUP searches the first column of this range.
  • Column number: the return column, counted from the left edge of the selected range. The first column is 1.
  • Match setting: FALSE requests an exact match; TRUE requests an approximate match.

Use an exact match for identifiers

When you need a particular customer or product, use an exact match. For example, =VLOOKUP(A2,$F$2:$H$100,3,FALSE) searches for the value in A2 in the first column of F2:H100 and returns the third column from a matching row. This is a separate illustrative formula you can adapt to your own practice data.

The dollar signs keep the lookup range fixed when copying the formula. Before trusting the result, check a few records manually. If Excel returns #N/A, check whether the item exists and whether spaces or mismatched text and number formats are preventing a match.

Use an approximate match for bands and thresholds

A score-to-grade table is a useful way to learn approximate matching. Arrange the first column in ascending order and use the lower boundary of each band. With TRUE, VLOOKUP can return the band whose starting value is the largest value less than or equal to the lookup value. A value below the smallest boundary returns #N/A.

Do not omit the final argument casually: VLOOKUP defaults to approximate matching. An unsorted threshold table can produce misleading results. Test values at each boundary before using the formula in a real report.

This is a recorded training lesson using sample data. Any tax-rate tables shown are historical practice examples, not current tax rates or tax advice.

Build Excel skills your team can use

Need help applying lookups and other Excel tools to everyday work? Book a free 15-minute conversation about private training. Explore custom training services, upcoming live webinars, or recorded courses.

Tom Fragale
Email: tom@pcwebinars.com
LinkedIn: https://www.linkedin.com/in/tomfragale
Website: https://pcwebinars.com

Leave a Reply

Your email address will not be published. Required fields are marked *