Combining IF VLOOKUP & ISBLANK Statements

[KClem]

I need to analyse the marks obtained for some children and turn them into a numerical number and finally show if they have achieved the target mark/score with a tick/cross. I have attached a spreadsheet that may help to explain what i need.

I need to find a more simple formula to do this in two steps rather than three.

I enter the marks for each child which could be a 2a, or 2b or 2c etc. Each of those marks have a numerical value, e.g. if they get a 2a in reading it is worth 17 points. For this group of children, the expected mark would be 2b which is 15 points. Thus, I need a separate column to show a tick if they get 2b/15 or higher such as 2a/17.

At the moment I achieve this in three steps
1. (Cell C5) Enter the mark
2. (Cell K5) Calculate the point score using IF & VLOOKUP (e.g. =IF(C5<>"",VLOOKUP(C5,$H:$I,2,0),"")); then
3. (Cell O5) Generate a tick if the expected mark (2b/15) was achieved using IF & IS Blank (e.g. =IF(ISBLANK(K5),"-",IF(K5<I15, "✗", "✓")))

I would like to skip step 2 and just enter the mark and the next column gives me the tick (if achieved) or cross (if not achieved). Is there a way to combine these formulas in one cell?

I would be grateful for any help and hope that I have explained my problem fully.

Thanks in advance

[JohnTopley]

In O,P,Q,R and S try ......

..=IF(C5<>"",IF(VLOOKUP(C5,$H:$I,2,0)<I15, "✗", "✓"))

=IF(D5<>"",IF(VLOOKUP(D5,$H:$I,2,0)<$E15, "✗", "✓"),"")

=IF(AND(,VLOOKUP(C5,$H:$I,2,0)>=I15,VLOOKUP(D5,$H:$I,2,0)>=I15),"✓","✗")

=IF(AND(VLOOKUP(C5,$H:$I,2,0)>=I15,VLOOKUP(D5,$H:$I,2,0)>=I15,VLOOKUP(E5,$H:$I,2,0)>=I15),"✓","✗")

=IF(E5<>"",IF(VLOOKUP(E5,$H:$I,2,0)<O15, "✗", "✓"),"-")

[KClem]

thank you, that has solved the problem.