I have been very proud of myself on this spreadsheet, but I'm stuck.
One one sheet, I have an attendance sheet, and on another sheet I have the
identical page, used for a point amount.

What I'm looking for, is if I put an A in a box, the corresponding box on
the other sheet will be a 5, if a T, 2, if an L, 2, and if a TL, a 5. What
formula would that be?

Thank you in advance.