On sheet one of my workbook I have my daily attendance record (e.g., date and
names of children absent) on sheet two of the same workbook I have my yearly
attendance record. I want to be able to come up with a formula so when I
enter the child's name on the daily attendance record it automatically
transfers the informations (A - meaning they are absent) to the yearly
attenance record in the appropriate cell for that date. Sample: Sheet 1 -
Cell A1=date; cells B1:B5 is where I enter the names of the children who are
absent. Sheet 2 - cell A5 where the information (A for absent) needs to go).
The formula needs to take into consideration the date and the students name
and return an "A" if both are true to cell A5 on sheet 2.

I hope that's clear enough. Easier to show you than explain.