Forum Discussion

FreddyJay's avatar
FreddyJay
Copper Contributor
Nov 03, 2021
Solved

Compare cells, if true, result in another column

Hi all, See attachment for example My students takes an exam. Student has 19 points (M5 =SUM(C5:L5)) of 110 points. 2,6 is than the result of the student his exam I want to compare colums ...
excel
  • FreddyJay's avatar
    FreddyJay
    Nov 03, 2021
    Never mind, i've , replaced with ; and it works.

    Thanks!
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 03, 2021
=VLOOKUP(M5,$O$1:$P$223,2,FALSE)

Is this the formula you are looking for?
FreddyJay's avatar
FreddyJay
Copper Contributor
Nov 03, 2021
Thanks for your reply Quadruple. When i do this, i've got an error

there's a problem with this formula not trying to type a formula
When the first characater is an equal......

What to do?
  • FreddyJay's avatar
    FreddyJay
    Copper Contributor
    Nov 03, 2021
    Never mind, i've , replaced with ; and it works.

    Thanks!

Resources