|
A |
B |
C |
D |
E |
F |
1 |
0.10 |
10 |
|
|
4.3 |
=VLOOKUP(E1,$A$1:$B$10,2,TRUE) |
2 |
1.00 |
20 |
|
|
4.2 |
=VLOOKUP(E2,$A$1:$B$10,2,TRUE) |
3 |
1.10 |
30 |
|
|
4.2 |
=VLOOKUP(E3,$A$1:$B$10,2,TRUE) |
4 |
2.00 |
40 |
|
|
4.7 |
=VLOOKUP(E4,$A$1:$B$10,2,TRUE) |
5 |
2.10 |
50 |
|
|
4 |
=VLOOKUP(E5,$A$1:$B$10,2,TRUE) |
6 |
3.00 |
60 |
|
|
4.1 |
=VLOOKUP(E6,$A$1:$B$10,2,TRUE) |
7 |
3.10 |
70 |
|
|
4.4 |
=VLOOKUP(E7,$A$1:$B$10,2,TRUE) |
8 |
4.00 |
80 |
|
|
4.3 |
=VLOOKUP(E8,$A$1:$B$10,2,TRUE) |
9 |
4.10 |
90 |
|
|
3.6 |
=VLOOKUP(E9,$A$1:$B$10,2,TRUE) |
10 |
5.00 |
100 |
|
|
2.4 |
=VLOOKUP(E10,$A$1:$B$10,2,TRUE) |
11 |
|
|
|
|
3 |
=VLOOKUP(E11,$A$1:$B$10,2,TRUE) |
12 |
|
|
|
|
3.2 |
=VLOOKUP(E12,$A$1:$B$10,2,TRUE) |
13 |
|
|
|
|
3.3 |
=VLOOKUP(E13,$A$1:$B$10,2,TRUE) |
Bookmarks