To use lookups in excel you need to share some key between both sets o
data such as Name.

Sheet 1. Sheet 2.
Name Name, Test1 Score, Test2 Score

Name Name, Test1 Score, Test2 Score
Name
...
...

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

This formula will do a lookup based on column a of sheet 1 if it find
a match in
column a of sheet 2 and will then return column B ( test 1 score) fro
sheet 2.

I know this is not exactly what you were asking for, but you lost me
bit with your discussion of the age factor

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=31516