software

I have two worksheets with a common unique identifier for each employee. One
worksheet has the date of employment, and the other worksheet has a list of
training courses that have been completed by each employee. I need to
identify employees hired within a date range and check to see if they have
all completed their courses. This would be fairly easy if I could merge the
spreadsheets and sort by date of employment. I've been told that the best way
to handle this is to do a comparative analysis using vlookup, but I can't
find any info on that process.

PLEASE HELP!

Hi Trish,
Assume that, on Sheet1, the emp ID is in column A, the employment date is in
column B, and column C is empty.
Assume that, on Sheet2, the emp ID is in column A and the training dates are
in column B.
Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
reference to reflect the last row of data on Sheet2. Then copy the formula
down.

=VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)

HTH
--
Ken Hudsonquot;Trish Ricequot; wrote:

gt; I have two worksheets with a common unique identifier for each employee. One
gt; worksheet has the date of employment, and the other worksheet has a list of
gt; training courses that have been completed by each employee. I need to
gt; identify employees hired within a date range and check to see if they have
gt; all completed their courses. This would be fairly easy if I could merge the
gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; find any info on that process.
gt;
gt; PLEASE HELP!

Thanks Ken! That's got me on the right track, but it only merged the header
in row 1, not the data in rows 2 through 5. Any thoughts?

quot;Ken Hudsonquot; wrote:

gt; Hi Trish,
gt; Assume that, on Sheet1, the emp ID is in column A, the employment date is in
gt; column B, and column C is empty.
gt; Assume that, on Sheet2, the emp ID is in column A and the training dates are
gt; in column B.
gt; Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
gt; reference to reflect the last row of data on Sheet2. Then copy the formula
gt; down.
gt;
gt; =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
gt;
gt; HTH
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;Trish Ricequot; wrote:
gt;
gt; gt; I have two worksheets with a common unique identifier for each employee. One
gt; gt; worksheet has the date of employment, and the other worksheet has a list of
gt; gt; training courses that have been completed by each employee. I need to
gt; gt; identify employees hired within a date range and check to see if they have
gt; gt; all completed their courses. This would be fairly easy if I could merge the
gt; gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; gt; find any info on that process.
gt; gt;
gt; gt; PLEASE HELP!

Please post back a sample of each worksheet so I can see the layouts.
--
Ken Hudsonquot;Trish Ricequot; wrote:

gt; Thanks Ken! That's got me on the right track, but it only merged the header
gt; in row 1, not the data in rows 2 through 5. Any thoughts?
gt;
gt; quot;Ken Hudsonquot; wrote:
gt;
gt; gt; Hi Trish,
gt; gt; Assume that, on Sheet1, the emp ID is in column A, the employment date is in
gt; gt; column B, and column C is empty.
gt; gt; Assume that, on Sheet2, the emp ID is in column A and the training dates are
gt; gt; in column B.
gt; gt; Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
gt; gt; reference to reflect the last row of data on Sheet2. Then copy the formula
gt; gt; down.
gt; gt;
gt; gt; =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; Ken Hudson
gt; gt;
gt; gt;
gt; gt; quot;Trish Ricequot; wrote:
gt; gt;
gt; gt; gt; I have two worksheets with a common unique identifier for each employee. One
gt; gt; gt; worksheet has the date of employment, and the other worksheet has a list of
gt; gt; gt; training courses that have been completed by each employee. I need to
gt; gt; gt; identify employees hired within a date range and check to see if they have
gt; gt; gt; all completed their courses. This would be fairly easy if I could merge the
gt; gt; gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; gt; gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; gt; gt; find any info on that process.
gt; gt; gt;
gt; gt; gt; PLEASE HELP!

Ken-
It's basically the same as your assumptio:

Sheet 1
Column A Column B Column C
UNIDDOE(blank)
1011/1/2004
1023/4/2000
1036/7/2004
1048/9/2002

Sheet 2
Column A Column B Column C
UNIDTraining(blank)
101Y
102N
103Y
104Y

I have Sheet 1 amp; sheet 2 in the same workbook.

Thanks!
-Trishquot;Ken Hudsonquot; wrote:

gt; Please post back a sample of each worksheet so I can see the layouts.
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;Trish Ricequot; wrote:
gt;
gt; gt; Thanks Ken! That's got me on the right track, but it only merged the header
gt; gt; in row 1, not the data in rows 2 through 5. Any thoughts?
gt; gt;
gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt;
gt; gt; gt; Hi Trish,
gt; gt; gt; Assume that, on Sheet1, the emp ID is in column A, the employment date is in
gt; gt; gt; column B, and column C is empty.
gt; gt; gt; Assume that, on Sheet2, the emp ID is in column A and the training dates are
gt; gt; gt; in column B.
gt; gt; gt; Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
gt; gt; gt; reference to reflect the last row of data on Sheet2. Then copy the formula
gt; gt; gt; down.
gt; gt; gt;
gt; gt; gt; =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt; --
gt; gt; gt; Ken Hudson
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have two worksheets with a common unique identifier for each employee. One
gt; gt; gt; gt; worksheet has the date of employment, and the other worksheet has a list of
gt; gt; gt; gt; training courses that have been completed by each employee. I need to
gt; gt; gt; gt; identify employees hired within a date range and check to see if they have
gt; gt; gt; gt; all completed their courses. This would be fairly easy if I could merge the
gt; gt; gt; gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; gt; gt; gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; gt; gt; gt; find any info on that process.
gt; gt; gt; gt;
gt; gt; gt; gt; PLEASE HELP!

Okay, so put this formula in cell C2 on Sheet1.

=VLOOKUP(A2,Sheet2!$A$2:$B$5,2,FALSE)

Change the number 5 in the $B$5 part of the entry to the last row number on
sheet2.

It will use the ID from cell A2 on sheet1, go to Sheet2, find the ID in
column A, and return the corresponding entry from column B on Sheet2.

The you'll need to copy the formula in cell C2 down the rest of the rows in
column C.--
Ken Hudsonquot;Trish Ricequot; wrote:

gt; Ken-
gt; It's basically the same as your assumptio:
gt;
gt; Sheet 1
gt; Column A Column B Column C
gt; UNIDDOE(blank)
gt; 1011/1/2004
gt; 1023/4/2000
gt; 1036/7/2004
gt; 1048/9/2002
gt;
gt; Sheet 2
gt; Column A Column B Column C
gt; UNIDTraining(blank)
gt; 101Y
gt; 102N
gt; 103Y
gt; 104Y
gt;
gt; I have Sheet 1 amp; sheet 2 in the same workbook.
gt;
gt; Thanks!
gt; -Trish
gt;
gt;
gt; quot;Ken Hudsonquot; wrote:
gt;
gt; gt; Please post back a sample of each worksheet so I can see the layouts.
gt; gt; --
gt; gt; Ken Hudson
gt; gt;
gt; gt;
gt; gt; quot;Trish Ricequot; wrote:
gt; gt;
gt; gt; gt; Thanks Ken! That's got me on the right track, but it only merged the header
gt; gt; gt; in row 1, not the data in rows 2 through 5. Any thoughts?
gt; gt; gt;
gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi Trish,
gt; gt; gt; gt; Assume that, on Sheet1, the emp ID is in column A, the employment date is in
gt; gt; gt; gt; column B, and column C is empty.
gt; gt; gt; gt; Assume that, on Sheet2, the emp ID is in column A and the training dates are
gt; gt; gt; gt; in column B.
gt; gt; gt; gt; Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
gt; gt; gt; gt; reference to reflect the last row of data on Sheet2. Then copy the formula
gt; gt; gt; gt; down.
gt; gt; gt; gt;
gt; gt; gt; gt; =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
gt; gt; gt; gt;
gt; gt; gt; gt; HTH
gt; gt; gt; gt; --
gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have two worksheets with a common unique identifier for each employee. One
gt; gt; gt; gt; gt; worksheet has the date of employment, and the other worksheet has a list of
gt; gt; gt; gt; gt; training courses that have been completed by each employee. I need to
gt; gt; gt; gt; gt; identify employees hired within a date range and check to see if they have
gt; gt; gt; gt; gt; all completed their courses. This would be fairly easy if I could merge the
gt; gt; gt; gt; gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; gt; gt; gt; gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; gt; gt; gt; gt; find any info on that process.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; PLEASE HELP!

Ken-
That took care of the data for row 2, but it's still only populating one row
at a time. I can drag the formula down from C1 to C5, but it may become a
bit cumbersome later as I anticipate adding 3,000 to 4,000 name this year.

Any other help you can give on populating more than one row would be
appreciated, but in the meantime... thank you for giving me a very good start!
-Trishquot;Ken Hudsonquot; wrote:

gt; Okay, so put this formula in cell C2 on Sheet1.
gt;
gt; =VLOOKUP(A2,Sheet2!$A$2:$B$5,2,FALSE)
gt;
gt; Change the number 5 in the $B$5 part of the entry to the last row number on
gt; sheet2.
gt;
gt; It will use the ID from cell A2 on sheet1, go to Sheet2, find the ID in
gt; column A, and return the corresponding entry from column B on Sheet2.
gt;
gt; The you'll need to copy the formula in cell C2 down the rest of the rows in
gt; column C.
gt;
gt;
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;Trish Ricequot; wrote:
gt;
gt; gt; Ken-
gt; gt; It's basically the same as your assumptio:
gt; gt;
gt; gt; Sheet 1
gt; gt; Column A Column B Column C
gt; gt; UNIDDOE(blank)
gt; gt; 1011/1/2004
gt; gt; 1023/4/2000
gt; gt; 1036/7/2004
gt; gt; 1048/9/2002
gt; gt;
gt; gt; Sheet 2
gt; gt; Column A Column B Column C
gt; gt; UNIDTraining(blank)
gt; gt; 101Y
gt; gt; 102N
gt; gt; 103Y
gt; gt; 104Y
gt; gt;
gt; gt; I have Sheet 1 amp; sheet 2 in the same workbook.
gt; gt;
gt; gt; Thanks!
gt; gt; -Trish
gt; gt;
gt; gt;
gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt;
gt; gt; gt; Please post back a sample of each worksheet so I can see the layouts.
gt; gt; gt; --
gt; gt; gt; Ken Hudson
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Thanks Ken! That's got me on the right track, but it only merged the header
gt; gt; gt; gt; in row 1, not the data in rows 2 through 5. Any thoughts?
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi Trish,
gt; gt; gt; gt; gt; Assume that, on Sheet1, the emp ID is in column A, the employment date is in
gt; gt; gt; gt; gt; column B, and column C is empty.
gt; gt; gt; gt; gt; Assume that, on Sheet2, the emp ID is in column A and the training dates are
gt; gt; gt; gt; gt; in column B.
gt; gt; gt; gt; gt; Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
gt; gt; gt; gt; gt; reference to reflect the last row of data on Sheet2. Then copy the formula
gt; gt; gt; gt; gt; down.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I have two worksheets with a common unique identifier for each employee. One
gt; gt; gt; gt; gt; gt; worksheet has the date of employment, and the other worksheet has a list of
gt; gt; gt; gt; gt; gt; training courses that have been completed by each employee. I need to
gt; gt; gt; gt; gt; gt; identify employees hired within a date range and check to see if they have
gt; gt; gt; gt; gt; gt; all completed their courses. This would be fairly easy if I could merge the
gt; gt; gt; gt; gt; gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; gt; gt; gt; gt; gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; gt; gt; gt; gt; gt; find any info on that process.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; PLEASE HELP!

Trish,
Here is an Excel tip that should help you.
Put the formula into cell C2.
Click on C2 to select the cell.
Put the cursor on the lower right corner of the cell and it will turn into a
cross.
Double click on the cross and the formula will copy down automatically to
the last row with an entry in column B.
--
Ken Hudsonquot;Trish Ricequot; wrote:

gt; Ken-
gt; That took care of the data for row 2, but it's still only populating one row
gt; at a time. I can drag the formula down from C1 to C5, but it may become a
gt; bit cumbersome later as I anticipate adding 3,000 to 4,000 name this year.
gt;
gt; Any other help you can give on populating more than one row would be
gt; appreciated, but in the meantime... thank you for giving me a very good start!
gt; -Trish
gt;
gt;
gt; quot;Ken Hudsonquot; wrote:
gt;
gt; gt; Okay, so put this formula in cell C2 on Sheet1.
gt; gt;
gt; gt; =VLOOKUP(A2,Sheet2!$A$2:$B$5,2,FALSE)
gt; gt;
gt; gt; Change the number 5 in the $B$5 part of the entry to the last row number on
gt; gt; sheet2.
gt; gt;
gt; gt; It will use the ID from cell A2 on sheet1, go to Sheet2, find the ID in
gt; gt; column A, and return the corresponding entry from column B on Sheet2.
gt; gt;
gt; gt; The you'll need to copy the formula in cell C2 down the rest of the rows in
gt; gt; column C.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Ken Hudson
gt; gt;
gt; gt;
gt; gt; quot;Trish Ricequot; wrote:
gt; gt;
gt; gt; gt; Ken-
gt; gt; gt; It's basically the same as your assumptio:
gt; gt; gt;
gt; gt; gt; Sheet 1
gt; gt; gt; Column A Column B Column C
gt; gt; gt; UNIDDOE(blank)
gt; gt; gt; 1011/1/2004
gt; gt; gt; 1023/4/2000
gt; gt; gt; 1036/7/2004
gt; gt; gt; 1048/9/2002
gt; gt; gt;
gt; gt; gt; Sheet 2
gt; gt; gt; Column A Column B Column C
gt; gt; gt; UNIDTraining(blank)
gt; gt; gt; 101Y
gt; gt; gt; 102N
gt; gt; gt; 103Y
gt; gt; gt; 104Y
gt; gt; gt;
gt; gt; gt; I have Sheet 1 amp; sheet 2 in the same workbook.
gt; gt; gt;
gt; gt; gt; Thanks!
gt; gt; gt; -Trish
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Please post back a sample of each worksheet so I can see the layouts.
gt; gt; gt; gt; --
gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks Ken! That's got me on the right track, but it only merged the header
gt; gt; gt; gt; gt; in row 1, not the data in rows 2 through 5. Any thoughts?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Hi Trish,
gt; gt; gt; gt; gt; gt; Assume that, on Sheet1, the emp ID is in column A, the employment date is in
gt; gt; gt; gt; gt; gt; column B, and column C is empty.
gt; gt; gt; gt; gt; gt; Assume that, on Sheet2, the emp ID is in column A and the training dates are
gt; gt; gt; gt; gt; gt; in column B.
gt; gt; gt; gt; gt; gt; Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
gt; gt; gt; gt; gt; gt; reference to reflect the last row of data on Sheet2. Then copy the formula
gt; gt; gt; gt; gt; gt; down.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; I have two worksheets with a common unique identifier for each employee. One
gt; gt; gt; gt; gt; gt; gt; worksheet has the date of employment, and the other worksheet has a list of
gt; gt; gt; gt; gt; gt; gt; training courses that have been completed by each employee. I need to
gt; gt; gt; gt; gt; gt; gt; identify employees hired within a date range and check to see if they have
gt; gt; gt; gt; gt; gt; gt; all completed their courses. This would be fairly easy if I could merge the
gt; gt; gt; gt; gt; gt; gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; gt; gt; gt; gt; gt; gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; gt; gt; gt; gt; gt; gt; find any info on that process.
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; PLEASE HELP!

AWESOME! Thanks Ken! That solves it all now.
I really appreciate all of your help on this!

quot;Ken Hudsonquot; wrote:

gt; Trish,
gt; Here is an Excel tip that should help you.
gt; Put the formula into cell C2.
gt; Click on C2 to select the cell.
gt; Put the cursor on the lower right corner of the cell and it will turn into a
gt; cross.
gt; Double click on the cross and the formula will copy down automatically to
gt; the last row with an entry in column B.
gt; --
gt; Ken Hudson
gt;
gt;
gt; quot;Trish Ricequot; wrote:
gt;
gt; gt; Ken-
gt; gt; That took care of the data for row 2, but it's still only populating one row
gt; gt; at a time. I can drag the formula down from C1 to C5, but it may become a
gt; gt; bit cumbersome later as I anticipate adding 3,000 to 4,000 name this year.
gt; gt;
gt; gt; Any other help you can give on populating more than one row would be
gt; gt; appreciated, but in the meantime... thank you for giving me a very good start!
gt; gt; -Trish
gt; gt;
gt; gt;
gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt;
gt; gt; gt; Okay, so put this formula in cell C2 on Sheet1.
gt; gt; gt;
gt; gt; gt; =VLOOKUP(A2,Sheet2!$A$2:$B$5,2,FALSE)
gt; gt; gt;
gt; gt; gt; Change the number 5 in the $B$5 part of the entry to the last row number on
gt; gt; gt; sheet2.
gt; gt; gt;
gt; gt; gt; It will use the ID from cell A2 on sheet1, go to Sheet2, find the ID in
gt; gt; gt; column A, and return the corresponding entry from column B on Sheet2.
gt; gt; gt;
gt; gt; gt; The you'll need to copy the formula in cell C2 down the rest of the rows in
gt; gt; gt; column C.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Ken Hudson
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Ken-
gt; gt; gt; gt; It's basically the same as your assumptio:
gt; gt; gt; gt;
gt; gt; gt; gt; Sheet 1
gt; gt; gt; gt; Column A Column B Column C
gt; gt; gt; gt; UNIDDOE(blank)
gt; gt; gt; gt; 1011/1/2004
gt; gt; gt; gt; 1023/4/2000
gt; gt; gt; gt; 1036/7/2004
gt; gt; gt; gt; 1048/9/2002
gt; gt; gt; gt;
gt; gt; gt; gt; Sheet 2
gt; gt; gt; gt; Column A Column B Column C
gt; gt; gt; gt; UNIDTraining(blank)
gt; gt; gt; gt; 101Y
gt; gt; gt; gt; 102N
gt; gt; gt; gt; 103Y
gt; gt; gt; gt; 104Y
gt; gt; gt; gt;
gt; gt; gt; gt; I have Sheet 1 amp; sheet 2 in the same workbook.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks!
gt; gt; gt; gt; -Trish
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Please post back a sample of each worksheet so I can see the layouts.
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thanks Ken! That's got me on the right track, but it only merged the header
gt; gt; gt; gt; gt; gt; in row 1, not the data in rows 2 through 5. Any thoughts?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Ken Hudsonquot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Hi Trish,
gt; gt; gt; gt; gt; gt; gt; Assume that, on Sheet1, the emp ID is in column A, the employment date is in
gt; gt; gt; gt; gt; gt; gt; column B, and column C is empty.
gt; gt; gt; gt; gt; gt; gt; Assume that, on Sheet2, the emp ID is in column A and the training dates are
gt; gt; gt; gt; gt; gt; gt; in column B.
gt; gt; gt; gt; gt; gt; gt; Enter this formula in cell C1 on Sheet1. You'll need to adjust the $B$5
gt; gt; gt; gt; gt; gt; gt; reference to reflect the last row of data on Sheet2. Then copy the formula
gt; gt; gt; gt; gt; gt; gt; down.
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt; gt; Ken Hudson
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; quot;Trish Ricequot; wrote:
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; I have two worksheets with a common unique identifier for each employee. One
gt; gt; gt; gt; gt; gt; gt; gt; worksheet has the date of employment, and the other worksheet has a list of
gt; gt; gt; gt; gt; gt; gt; gt; training courses that have been completed by each employee. I need to
gt; gt; gt; gt; gt; gt; gt; gt; identify employees hired within a date range and check to see if they have
gt; gt; gt; gt; gt; gt; gt; gt; all completed their courses. This would be fairly easy if I could merge the
gt; gt; gt; gt; gt; gt; gt; gt; spreadsheets and sort by date of employment. I've been told that the best way
gt; gt; gt; gt; gt; gt; gt; gt; to handle this is to do a comparative analysis using vlookup, but I can't
gt; gt; gt; gt; gt; gt; gt; gt; find any info on that process.
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; PLEASE HELP!