The name “Dodson” is on A5, the lookup is from B5, the table A16:B19, the value in the second column of the table, but am looking for the precise result of a VLOOKUP. The formula I have is: =VLOOKUP($B5,$A$16:$B$19,2,FALSE) students: A B C ======================== Dodson Silver 400 Jones Gold 550 […]