Hi,
Try the following by placing the VLOOKUP in cell A1 (colA)
=VLOOKUP(B1, SHEET2!A1:B5, 2, FALSE)
Explanation:
In cell A1 you place the VLOOKUP function. After the bracket you click on the cell that will contain the value to look for (in your case ColB). Next you select the range where to look, in your case sheet2 A1:B5. You can just select this using the mouse.
Next enter the column which contains the return value. In your case column 2.
Finally the last argument you need to type or click FALSE. This will result in a specific result.
So the above formula will return "Damaged" if the user types in a 1 in the first sheet in cell B1.
Maurice