I am trying to use a vlookup function to extract data from a large spreadsheet into a more concise version. However not all of my lookup values are unique. With a basic vlookup function it always gives me the values in the row associated with the first instance of my lookup ID. Is there a function that will allow the formula to pull the values in the row of a duplicate ID?