lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
The vlookup = =VLOOKUP(B2,$H$2:$I$5,2,1) with approximate values is working if the table like this
This table start H2:I5
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
but is I change the table above to
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
then I get wrong answers
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Why is that? Thank you so much.
The vlookup = =VLOOKUP(B2,$H$2:$I$5,2,1) with approximate values is working if the table like this
This table start H2:I5
average | grade |
0 | f |
50 | c |
60 | b |
80 | a |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
name | average | grade |
mary1 | 91 | a |
mary2 | 40 | f |
mary3 | 12 | f |
mary4 | 76 | b |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
but is I change the table above to
average | grade |
80 | a |
60 | b |
50 | c |
0 | f |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
then I get wrong answers
name | average | grade |
mary1 | 91 | f |
mary2 | 40 | #N/A |
mary3 | 12 | #N/A |
mary4 | 76 | f |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Why is that? Thank you so much.