The core idea of VLOOKUP is to look up information in a spreadsheet table and place it in another.
For example, suppose this is the table in Sheet1:
John 12/25/1990
Jane 1/1/2000
In Sheet2, place John, Andy, and Jane in A1, A2, and A3.
In B1, to the right of John, I placed:
=VL...