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¤t=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¤t=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 .
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¤t=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¤t=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 .