I am trying to find the closest bigger value in A2:A100, using as lookup value P2. I input in Q2 the following array formula (ctrl+shift+enter): =LARGE(J2:J100;COUNTIF(J2:J100;">"&$P$2)) This formula returns "#DIV/0!". I assume that cells in column J that are currently displaying "#DIV/0!" are the cause of the problem. It is kind of important not to have false zeroes in column J, so i cannot use the IFERROR function.

Could anyone please help me to get excel to ignore these cells in column J and find the closest bigger value in regards to the lookup value in P2? Thank you in advance!