This is what the formula would look like if I could type it in this way.
Just need help with translating to excel.

If cell E1 ("the child's name") on sheet 2 matches any cell from B46 thru
I52 ("which could be any child including said child") on sheet 1 and cell P7
(which is the date) on sheet 2 matches H44 (which is the date) on sheet 1
then cell P8 (on sheet 2) = A (for absent).

Note: If there is not a match then nothing should happen in cell P8. Also
both the names and the dates must match to return an "A" for absent. I
can send an email of my layout if I haven't been clear enough.



Thanks,

Mike