Forum Discussion
AnEntree
Aug 23, 2021Copper Contributor
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...
Detlef_Lewin
Aug 23, 2021Silver Contributor
If you check the cells with ISNUMER() then it will spill out FALSE because your formulas evaluate to "0" and not to 0.