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?

Resources