Thank you Dave, Ron for the help. Will try it today.

"Ron Coderre" wrote:

Good point....
I puzzled a bit on that one, but reasoned that the same course could be
taught by different instructors at different dates. Consequently, the course
name and the course date would have to be taken into consideration.

Intro to Excel...Instructor1.......10/13/2005
Intro to Excel...Instructor2.......10/25/2005

If the OP is willing to put both tables in the same workbook and the tables
aren't inordinately large, formulas could be used. Probably the typical
array formulas that we use for multiple criteria.

Otherwise, a little SQL can go a long way with minimal update effort
(Click/data refresh).

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Dave O" wrote:

The common field appears to be the COURSE field. This means you can
use that in a VLOOKUP function, which retrieves data from a range based
on a matching field.