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?