Rank function with if statement

[ExcelNovice]

I'm trying to use the Rank function with if statement but without success.
Here is the formula:
=IF(OR(BF36="Tea",BF36="Cho"),"ignore",RANK(BE36,$BE$9:$BE$486,1))
Any help fixing the formula would be great, thanks.

 

[jtakw]

You're welcome, thanks for the feedback.

 

[Zot]

I also get confused what was wrong here. I tried to simulate the problem using the VLOOKUP and RANK. That was not the problem for sure. I also put VLOOKUP formula at BF36 with "tea" as the lookup result and I still could not simulate the problem. Maybe I just did not understand the problem

Anyway, the solution around it