Worksheet 1 has one VLOOKUP function that provides an employee ID number
after it has been placed in a cell (via the drop-down list selection of the
last name) which comes from an external data source via an SQL query.

Worksheet 2 contains other employee related data (personnel reviews) that I
want to be able to pull into Worksheet 1 by using this employee ID number to
reference (VLOOKUP?) the same Employee ID number from Worksheet 2 which is
also provided by another external data source and also via an SQL query.

I'm trying to compare the two sets of external data (referenced by the
employee ID number - common to both external data sets) and display this on
Worksheet 1.

In a nutshell I want to use the employee ID number on Worksheet 1 to look at
Worksheet 2, search for a match of employee ID number and to place the most
current personnel review date for that staff member.

I believe using VLOOKUP functions should do this but I'm not sure how to tie
this all together. I appreciate any help that may be offered. If further
information is needed please advise.

Mike