Insert a column before your lookup table and concatenate the name and
date columns. ie. =X1&Y1, assuming your table, after the new column
begins in X1.

Then use a vlookup formula with concatenated string.

e.g. =vlookup(A1&B1,$W$1:$Y$100,3,0), Where A1 contains the name to
lookup and B1 contains the corresponding date to lookup, W1:Y100 is
the lookup table with column W containing the concatenated Name&Date
columns. Change references and ranges to match your situation. Then
copy down the formulas.

You can always hide column W.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=493887