Use the NVLOOKUP function to lookup and return the nth value (the second, third, or nth match) in an Excel range. NVLOOKUP uses the following arguments: =NVLOOKUP(lookup_value, lookup_range, column_number, nth, [optional closest-match])