Hi all,
I am stuck on excel again,
What I am trying to do is matching the result and name in different month
1 MONTH AND NAME WILL BE IN PUT MANULLY
2 SHOULD I USE VLOOKUP MATCH , INDEX OR SOMETHING ELSE?
<TBODY>
</TBODY>
I am stuck on excel again,
What I am trying to do is matching the result and name in different month
1 MONTH AND NAME WILL BE IN PUT MANULLY
2 SHOULD I USE VLOOKUP MATCH , INDEX OR SOMETHING ELSE?
A | B | C | D | E | F | G | H | I | J | K | L | |
1 | MONTH | NAME | RESULT1 | RESULT2 | RESULT3 | |||||||
2 | 1 | JAN | A | 0.819452 | 0.91458 | 0.061559 | ||||||
3 | B | 0.604847 | 0.204047 | 0.272456 | ||||||||
4 | C | 0.356055 | 0.0492 | 0.72544 | INPUT | |||||||
5 | D | 0.171849 | 0.257119 | 0.666312 | MONTH | 2 | ||||||
6 | E | 0.428171 | 0.196943 | 0.615605 | NAME | C | ||||||
7 | F | 0.822386 | 0.019996 | 0.17076 | RESULT 1 | |||||||
8 | G | 0.338101 | 0.155048 | 0.474083 | RESULT 2 | |||||||
9 | ||||||||||||
10 | ||||||||||||
11 | ||||||||||||
12 | ||||||||||||
13 | ||||||||||||
14 | 2 | FEB | A | 0.838532 | 0.985274 | 0.287719 | ||||||
15 | B | 0.226938 | 0.277534 | 0.538367 | ||||||||
16 | C | 0.296784 | 0.587132 | 0.069183 | ||||||||
17 | D | 0.4415 | 0.165303 | 0.609791 | ||||||||
18 | E | 0.713151 | 0.308744 | 0.189958 | ||||||||
19 | F | 0.234523 | 0.015618 | 0.744492 | ||||||||
20 | G | 0.788012 | 0.801931 | 0.718554 | ||||||||
21 | ||||||||||||
22 | ||||||||||||
23 | ||||||||||||
24 | ||||||||||||
25 | 3 | MAR | A | 0.466763 | 0.06652 | 0.096242 | ||||||
26 | B | 0.465833 | 0.993445 | 0.27822 | ||||||||
27 | C | 0.601396 | 0.541691 | 0.076991 | ||||||||
28 | D | 0.504348 | 0.654465 | 0.539561 | ||||||||
29 | E | 0.025089 | 0.819551 | 0.199993 | ||||||||
30 | F | 0.120118 | 0.129761 | 0.00493 | ||||||||
31 | G | 0.482379 | 0.973842 | 0.153111 |
<TBODY>
</TBODY>