SOLVED

Compare cells, if true, result in another column

%3CLINGO-SUB%20id%3D%22lingo-sub-2921041%22%20slang%3D%22en-US%22%3ECompare%20cells%2C%20if%20true%2C%20result%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921041%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20all%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ESee%20attachment%20for%20example%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EMy%20students%20takes%20an%20exam.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EStudent%20has%2019%20points%20(M5%20%3DSUM(C5%3AL5))%20of%20110%20points.%3C%2FP%3E%3CP%3E2%2C6%20is%20than%20the%20result%20of%20the%20student%20his%20exam%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%3EI%20want%20to%20compare%20colums%20M%20with%20column%20O%20and%20column%20O%20with%20column%20P.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EResult%20column%20P%20sets%20automatically%20in%20column%20B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EExample%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20want%20that%20Excel%20automatically%20set%20B5%20to%202%2C6%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EM5%20result%20compare%20with%20O1%3AO223%2C%20if%20true%20compare%20it%20with%20P1%3AP223%20and%20that's%20the%20result%20for%20B5.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWhat's%20the%20correct%20formula%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2921041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2921130%22%20slang%3D%22en-US%22%3ERe%3A%20Compare%20cells%2C%20if%20true%2C%20result%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921130%22%20slang%3D%22en-US%22%3E%3DVLOOKUP(M5%2C%24O%241%3A%24P%24223%2C2%2CFALSE)%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20the%20formula%20you%20are%20looking%20for%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2921139%22%20slang%3D%22en-US%22%3ERe%3A%20Compare%20cells%2C%20if%20true%2C%20result%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2921139%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20reply%20Quadruple.%20When%20i%20do%20this%2C%20i've%20got%20an%20error%3CBR%20%2F%3E%3CBR%20%2F%3Ethere's%20a%20problem%20with%20this%20formula%20not%20trying%20to%20type%20a%20formula%3CBR%20%2F%3EWhen%20the%20first%20characater%20is%20an%20equal......%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20to%20do%3F%3C%2FLINGO-BODY%3E
New Contributor

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?

3 Replies
=VLOOKUP(M5,$O$1:$P$223,2,FALSE)

Is this the formula you are looking for?
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?
best response confirmed by allyreckerman (Microsoft)
Solution
Never mind, i've , replaced with ; and it works.

Thanks!