Formula changing when sorted

Hi all,


I have a very complicated formula, that works!, but when I sort the data the formulas look up the wrong value and it stops working.

How do I stop this from happening?

This is my formula:

=IFERROR(IF($N4=’Progress check conditions’!$B$4,VLOOKUP(‘Students Assessment Data’!$AX4,’Progress check conditions’!$C$4:$D$6,2,TRUE),IF($N4=’Progress check conditions’!$B$7,VLOOKUP(‘Students Assessment Data’!$AX4,’Progress check conditions’!$C$7:$D$9,2,TRUE),IF($N4=’Progress check conditions’!$B$10,VLOOKUP(‘Students Assessment Data’!$AX4,’Progress check conditions’!$C$10:$D$12,2,TRUE),IF($N4=’Progress check conditions’!$B$13,VLOOKUP(‘Students Assessment Data’!$AX4,’Progress check conditions’!$C$13:$D$15,2,TRUE),IF($N4=’Progress check conditions’!$B$16,VLOOKUP(‘Students Assessment Data’!$AX4,’Progress check conditions’!$C$16:$D$18,2,TRUE),VLOOKUP(‘Students Assessment Data’!$AX4,’Progress check conditions’!$C$19:$D$21,2,TRUE)))))),”No judgement”)



By: Alison

365 thoughts on “Formula changing when sorted

  1. App Iptv Brasil Gratuito

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. goyard

    I must get across my passion for your kindness giving support to men who have the need for help on this particular issue. Your personal dedication to passing the solution throughout became exceedingly useful and have without exception permitted professionals just like me to arrive at their desired goals. Your warm and helpful report means much a person like me and even further to my fellow workers. Many thanks; from all of us.

  3. toxicwap series

    Your style is unique in comparison to other folks I have read stuff from. Thank you for posting when you ave got the opportunity, Guess I all just book mark this site.

Comments are closed.