Excel VLOOKUP has the Range Lookup or TRUE / FALSE component that you should know how it works to desired data results.
One of the examples is the often requested VLOOKUP by teachers to assign a letter grade based on a test or semester numeric grade.