Compare cells, if true, result in another column

[FreddyJay]

Hi all,

See attachment for example

My students makes a exam.

I want compare two columns and return a result in an another column.
Example:

B5 result: M5 result compare with O1:O223, if true compare it with P1:P223 and that's the result

=SUM(C5:L5) result 19 . Searching 19 in column O and in column P is that 2,6.
Thats the result of my student his exam

I want that excel sets automatically cell B5 to 2,6.

What's the correct formula?

 

[Fluff]

Hi & welcome to MrExcel.
How about in B5

=VLOOKUP(M5,$O$2:$P$100,2,0)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Compare cells, if true, result in another column
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[FreddyJay]

I want to edit my first post, but i don't know where:

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?

 

[FreddyJay]

Thanks Fluff for your reply,

When i do that, i've get an error, see attachment

 

[Fluff]

What do you normally use as the separator in a formula?

 

[FreddyJay]

What do you normally use as the separator in a formula?

; i guess, i'm from the Netherlands

 

[Fluff]

In that case change the commas to semi-colons.

 

[FreddyJay]

In that case change the commas to semi-colons.

Thanks Fluff.
When i do that, i've got the #N/A error

 

[Fluff]

Are the values in column O numbers? It's impossible to tell from an image.