One of the columns in the spreadsheet is an ID for each landowner. Here's a simple example based on a question I was asked by one of our readers. a wildcard search) to the values in your lookup table. It also looks at how to do this when you want to return all values which are a partial match (i.e. This lesson shows you how to use the INDEX function (plus some other functions) to find all matching values in a list, and return a value from another column in the same row. But if your table includes your lookup value multiple times, you'll find that VLOOKUP can't do it.
Excel's VLOOKUP function is excellent when you want to find a value in a table based on a lookup value.
