vlookup a value not existing the table returning last value

[lezawang]

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.

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>

 

[lezawang]

Sorry ignore my post. In vlookup functuon, I forgot to say False/True. Thank you.

 

[shg]

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​	id​	first​	last​	dept​	salary​	​	​	​	​
2​	1​	john1	clark1	it	43 k		1​	43 k	H2: =IF(LOOKUP(G2, $A$2:$A$7) = G2, LOOKUP(G2, $A$2:$E$7), NA())
3​	2​	mary1	jones1	hr	38 k		3​	55 k
4​	3​	alex1	wilson1	sales	55 k		6​	17 k
5​	4​	sarah1	king1	marketing	97 k		7​	#N/A​
6​	5​	david1	lkim1	it	37 k
7​	6​	john2	clark2	it	17 k

 

[shg]

If the numbers in the list are always sequential from 1, just =index(e2:e7, id)