are your names not going to be entered case sensitive? I am asking because I was going to make named ranges that make unique lists so everything auto-populates.

For example, you have Mary and mary, and are treating them as the same, will this always be the case, or is this another typo?