Question: can vlookup return a date?
Answer: The VLOOKUP function locates the date value for Sept 4, and returns the value at the same row in the second column: 12,500. Note: the lookup value and the date values in the table must be valid Excel dates. To assign a grade based on a score, you can use the VLOOKUP function configured to perform an approximate match.