I have a sheet that is supposed to return to me a random item that matches criteria. The equation functions properly, but the shown result does not match what is calculated. I thought maybe it was just offsetting by an amount for some reason, but it’s never wrong by the same amount, and is also correct sometimes.
When examining each step of the equation with “evaluate formula” every step is correct, all the way down to the last “if(true,36,”help”)”… and then instead of “36” it shows one of the other row numbers that matches.
This is the simplified version, that is behaving in the same manner. The full equation indexes a list of several hundred items with many different categories.
=IF($F$2=”bottom”,LARGE(IF(I20:I39=”brown”,IF(F20:F39=”Pants”,ROW(B20:B39),0),0),RANDBETWEEN(1,COUNTIFS(E20:E39,$F$2,I20:I39,”Brown”))),”help”)
Screenshot of last step of evaluation and its result:
![Best nvme e.g. WD red for home / small business kubernetes Prometheus etcd [closed]](https://www.rubin.com.np/wp-content/themes/customizr/assets/front/img/thumb-standard-empty.png)
