Look up a value and display the score

[Seifeddine87]

hi am finding it hard to explain it but it should be easy in the example

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Score[/TD]
[TD]Level[/TD]
[TD][/TD]
[TD]Score[/TD]
[TD]Level[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10[/TD]
[TD]AA[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]=?????[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]20[/TD]
[TD]BB[/TD]
[TD][/TD]
[TD]15
[/TD]
[TD]AA[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]50[/TD]
[TD]CC[/TD]
[TD][/TD]
[TD]18[/TD]
[TD]AA[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]100[/TD]
[TD]DD[/TD]
[TD][/TD]
[TD]25[/TD]
[TD]BB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]200[/TD]
[TD]EE[/TD]
[TD][/TD]
[TD]70
[/TD]
[TD]CC[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

In E2:

=VLOOKUP(D2,A$2:B$6,2)

 

[JoeMo]

One way is to use the LOOKUP function provided that the scores in col A are arranged in ascending order. Copy E2 down.

Excel Workbook
	A	B	C	D	E
1	Score	Level		Score	Level
2	10	AA		10	AA
3	20	BB		15	AA
4	50	CC		18	AA
5	100	DD		25	BB
6	200	EE		70	CC
Sheet1

 

[Fluff]

How abbout
=INDEX($B$2:$B$6,MATCH(D2,$A$2:$A$6,1))