lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have table like below, so I wrote vlookup function. user will enter id # and vlookup will return the salary. the vlookup function works no problem. then I tried to enter id = 100 which is not existed in the table, vlookup returned to me the last salary 17K. I tried different ID not existed in the range and vlookup keeps returning the last salary! why is that? I expected #value message or something like that. Thank you so much.
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
I have table like below, so I wrote vlookup function. user will enter id # and vlookup will return the salary. the vlookup function works no problem. then I tried to enter id = 100 which is not existed in the table, vlookup returned to me the last salary 17K. I tried different ID not existed in the range and vlookup keeps returning the last salary! why is that? I expected #value message or something like that. Thank you so much.
id | first | last | dept | salary |
1 | john1 | clark1 | it | 43 k |
2 | mary1 | jones1 | hr | 38 k |
3 | alex1 | wilson1 | sales | 55 k |
4 | sarah1 | king1 | marketing | 97 k |
5 | david1 | lkim1 | it | 37 k |
6 | john2 | clark2 | it | 17 k |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>