To do this, use the VLOOKUP function. Important: Make sure the values in the first row have been sorted in an ascending order. In the above example, VLOOKUP looks for the first name of the student who has 6 tardies in the A2:B7 range. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.