Look up a value and display the score

Seifeddine87

Board Regular
Joined
Sep 7, 2015
Messages
96
hi am finding it hard to explain it but it should be easy in the example

ABCDEFG
1ScoreLevelScoreLevel
210AA10=?????
320BB15
AA
450CC18AA
5100DD25BB
6200EE70
CC
7

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,851
Office Version
2010
Platform
Windows
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
ABCDE
1ScoreLevelScoreLevel
210AA10
AA
320BB15AA
450CC18AA
5100DD25BB
6200EE70CC
Sheet1
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,956
Office Version
365
Platform
Windows
How abbout
=INDEX($B$2:$B$6,MATCH(D2,$A$2:$A$6,1))
 

Watch MrExcel Video

Forum statistics

Threads
1,099,573
Messages
5,469,473
Members
406,655
Latest member
pwilson06

This Week's Hot Topics

Top