Forum Discussion
FreddyJay
Nov 03, 2021Copper Contributor
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 M with column O and column O with column P.
Result column P sets automatically in column B
Example:
I want that Excel automatically set B5 to 2,6
M5 result compare with O1:O223, if true compare it with P1:P223 and that's the result for B5.
What's the correct formula?
- Never mind, i've , replaced with ; and it works.
Thanks!
3 Replies
- OliverScheurichGold Contributor=VLOOKUP(M5,$O$1:$P$223,2,FALSE)
Is this the formula you are looking for?