Hi there. Any help much appreciated

My formula HLOOKUP(P21,Levels!$C$7:$O$1800,MATCH(O21,Levels!$ A$7:$A$1800))
has worked fine for the last 10 years. All values in cells C7:O1800 have been
0.

My problem is, I now need to add a mixture of negative values (-20) to the
above range and my formula just won't return the negative value

I have tried the following formula to test
=IF(HLOOKUP(P21,Levels!$C$7:$O$1800,MATCH(O21,Leve ls!$A$7:$A$1800))0,1,22)
and
=IF(HLOOKUP(P21,Levels!$C$7:$O$1800,MATCH(O21,Leve ls!$A$7:$A$1800))<0,1,22)
but the returned for both < & value is always 22.

Thanks for you time