Vlookup is not working

[ruveenck]

hai
I have a table array ,i want to take the details from this array to another sheet
(please visit the link to view the picture:
<a href="http://s581.photobucket.com/albums/ss252/ruveenck/?action=view&current=vllokup1.jpg" target="_blank"><img src="http://i581.photobucket.com/albums/ss252/ruveenck/vllokup1.jpg" border="0" alt="Photobucket"></a>
In the next sheet i have given the vlookup function as ; =vlookup(D3,sheet2!B2:M12,3) .
and in the column D3, i have the value , if the value is in the array , this function is working properly , but if the value that i given in the column D3 is wrong , then the function is showing some other results. My question is , when if we given the value is not in the array , then the functioned column should be null or n/a . Here i am giving the second sheet picture please visit for your reference .
<a href="http://s581.photobucket.com/albums/ss252/ruveenck/?action=view&current=vllokup2.jpg" target="_blank"><img src="http://i581.photobucket.com/albums/ss252/ruveenck/vllokup2.jpg" border="0" alt="Photobucket"></a>
Please help me to rectify this error .

 

[VoG]

Try adding FALSE as the fourth argument

=VLOOKUP(value,table array,offset,FALSE)

 

[ruveenck]

but sir , first time i was given that equation , (=VLOOKUP(value,table array,offset,FALSE) still it not working . If we give "false" in the end , then it viewing as "#N/A " .

 

[VoG]

That means it is not finding a match. See http://www.contextures.com/xlFunctions02.html#trouble

 

[ruveenck]

tnk u sir... i 'll check & inform you