Nested HLOOKUP returns "FALSE" in cell where result should be "0.00"

The formula I'm using in cell EU10 is:
=IFERROR(IF(HLOOKUP($F10,$M$2:$ES$170,(ROW($F10)-1),0),(HLOOKUP($F10,$M$2:$ES$170,(ROW($F10)-1),0))),"")

The lookup value is in cell F10
The table array is M2:ES170

The same value appears in F10 as M2, then in that column I'm pulling back the value in row F

This currently works perfectly across all rows and columns until the value I am trying to return in a given row/column contains "0.00" then in column EU it results in "FALSE".

Do I need to put in an extra step to say if cell contains 0.00 show 0.00, else do the formula? If so I don't know how to add that into the already nested formula.

Try this ..

=IFERROR(HLOOKUP($F10,$M$2:$ES$170,(ROW($F10)-1),0),"")

returns blank if no match

Perfect, thank you. Just taking out the IF rule worked, and returns 0.00 when I need it to and blank when I don't.

Thanks again!

If your query has been addressed could you please mark thread as solved ("Thread Tools" at top of first post).