Very strange formatting affecting match function

TLDR: Look at the video link. My match function is acting very strange. The formula is below. Basically, it's supposed to ignore zeros and return the cell number of the first number in a range. Howe...