we are evaluating the excel library and found some weird case,
We tried to read some result from a cell with formule like this,
=IF($P5>0,LOOKUP($P5,Freq!$B1:$AE2),””) => FAILED
But the value seems incorrect , while we tried different way to specify the range as following,
=IF($P5>0,LOOKUP($P5,Freq!$B1:$AE1,Freq!$B2:$AE2),””) =>This one is OK
Could you help to verify ?