Formula help

[jennyL]

Hi,Some help please. I've looked at LOOKUPs, IF, ANDs and I can't seem to figure out the correct formula to use.

Column A contains a half year score and Column B contains a full year score, Column C is the 'reference' for the final year score.
I'm looking for a formula/way for excel to return the Final Result.
Hope this makes sense
[TABLE="width: 500"]
<tbody>[TR]
[TD]HY Score
[/TD]
[TD]FY Score[/TD]
[TD]Final result
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
There are 15 rows in total.
Thanks in advance for your help

 

[FormR]

I have the values for column A and B and would like Excel to return the value of column C:

Hi, do you mean you have the A & B values somewhere else and want to use that table to lookup the C value?

If so - here is one option:

Excel 2013/2016
	A	B	C	D	E	F	G
1	KPI	Behaviour	Final		KPI	Behaviour	Result
2	1. Missed	1. Unacceptable	1. Unaccetable		2. Below	2. Acceptable	2. Low Performer
3	1. Missed	2. Acceptable	2. Low Performer		1. Missed	3. Exceptional	2. Low Performer
4	1. Missed	3. Exceptional	2. Low Performer		5. Exceptional	2. Acceptable	4. Exceptional
5	2. Below	1. Unacceptable	1. Unaccetable
6	2. Below	2. Acceptable	2. Low Performer
7	2. Below	3. Exceptional	2. Low Performer
8	3. On Target	1. Unacceptable	2. Low Performer
9	3. On Target	2. Acceptable	3. Successful
10	3. On Target	3. Exceptional	4. Exceptional
11	4. Exceeds	1. Unacceptable	2. Low Performer
12	4. Exceeds	2. Acceptable	3. Successful
13	4. Exceeds	3. Exceptional	4. Exceptional
14	5. Exceptional	1. Unacceptable	2. Low Performer
15	5. Exceptional	2. Acceptable	4. Exceptional
16	5. Exceptional	3. Exceptional	4. Exceptional
Sheet1

Cell Formulas
Range	Formula
G2	=INDEX($C$2:$C$16,MATCH(1,INDEX(($A$2:$A$16=E2)*($B$2:$B$16=F2),0),0))

 

[jennyL]

Thanks everyone for all of your help.
I hadn't used the INDEX and MATCH function before. I have now figured it out and am very happy.
Enjoy the rest of your day.