You to use true/false at the end of the formula to get result.

http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.contextures.com/xlFunctions02.html

Go through the above link i hope your issue would solve.