My current table form is
<colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;">
<col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;">
<col width="150" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5485;">
<tbody>
</tbody>
I requred following value
reference value ( from Column B ) from smallest value (column C) in week 4
Lookup value 1 : week 4 ( column A )
Lookup value 2 : smallest in week 4 from column C
Answer : Item 1
A | B | C | |
1 | Week No | Area | Compliance |
2 | Week 1 | Item 1 | 50.00% |
3 | Week 1 | Item 2 | 60.00% |
4 | Week 1 | Item 3 | 70.00% |
5 | Week 2 | Item 1 | 80.00% |
6 | Week 2 | Item 2 | 55.00% |
7 | Week 2 | Item 3 | 66.00% |
8 | Week 2 | Item 5 | 56.00% |
9 | Week 3 | Item 1 | 53.00% |
10 | Week 3 | Item 2 | 88.00% |
11 | Week 3 | Item 3 | 95.00% |
12 | Week 3 | Item 4 | 99.00% |
13 | Week 3 | Item 5 | 100.00% |
14 | Week 4 | Item 1 | 0.00% |
15 | Week 4 | Item 2 | 35.00% |
16 | Week 4 | Item 5 | 99.00% |
17 | Week 4 | Item 6 | 100.00% |
I requred following value
reference value ( from Column B ) from smallest value (column C) in week 4
Lookup value 1 : week 4 ( column A )
Lookup value 2 : smallest in week 4 from column C
Answer : Item 1