I get 1 only if I am searching for the same thing that is in column C1. I don't think it's my settings because I can start a new document on excel online, copy the formula and I still end up with the same answer. I appreciate you trying to help me. I'm not sure what's going on.