Hi everyone,

I never imagined that the formula in the column would affect the sorting
order in any way, but it does in my case.

Below is the formula in that I have in Col I, and I'd like to sort it in
Ascending order, but the result is that it sorts with all the empty rows on
top and the one with the result from the formula at the bottom. I assume it
consider the "I" in the "IF" function in the formula, but I'm not sure.

Can anyone tell me how to fix this please?

=IF(E2="","",IF(J2="X","Priority
#1",IF(ISNA(VLOOKUP(E2,PriorityList,4,0)),"No Priority
Found",VLOOKUP(E2,PriorityList,4,FALSE))))

Thank you very much,
Neon520