SEE: 83 Excel tips every user should master ... ID and the date using the personnel value as the search term (K1). Both functions use the value in K1, Luke, as the search term.

Microsoft Excel is one of the most useful programs ever developed in the history of computing. One function that anyone ... we break down an example of how to use VLOOKUP the right way.