I found the solution for simply returning the row. However, that is not exactly what I'm looking for. I filtered a column on my spreadsheet for dates < 1/1/16 and pasted the values onto another sheet. Now I (think) I want to use Vlookup to find other rows on the first spreadsheet that match a particular column for the dates >1/1/16 but < 1/1/17. Then I want the entire matching row from the first spreadsheet returned. Am I making sense yet???