Hi
I am trying to give candidates and A,B,C tag depending on their score which I am checking via a VLOOKUP.
Score >=0 gets an A
Score >=1 gets a B
Score >=2 gets a C
is not giving me the desired output. Candidate with a score of 3 outputs as an A when he should be C.=IF(VLOOKUP(A34,'scores'!$A$1:$B$100,2,FALSE)>=0,"A",IF(VLOOKUP(A34,'scores'!$A$1:$B$100,2,FALSE)>=1,"B","C"))
Can anyone help? Is their a better way to approach this?
Thanks in advance
Bookmarks