I am trying to create a formula within a worksheet which will look up
standardised test scores tabulated in another sheet. Standardised test
scores are calculated depending upon chronological age in years and months
and the test score of the child concerned. Currently my worksheet calculates
the chronological age, but in two separate columns - I don't know if I need
to reduce this to months and change the column heading on the second sheet.
The test score is included on my first sheet but I also don't know how to get
excel to look up using this variable. Can anyone help please?

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

Thanks - I'll try and see what happens. Age is the column headings in one
table, with the test score in Column A so cells in the table give a
standardised score for a child of a particular age who achieves a particular
test score. It is because these vary from child to child that I don't know
what to put into my formula. It would be easy if I could just go to a
particular cell! Thanks again - help was appreciated!

"crispbd" wrote:


To use lookups in excel you need to share some key between both sets of
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 finds
a match in
column a of sheet 2 and will then return column B ( test 1 score) from
sheet 2.

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


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=315168