What Scott said...
Note that we both put a dollar sign in front of the column reference ($A).
That tells it no matter what column you are in, check the value in column A.
Try it for yourself. Follow the step-by-step instructions I gave you exactly, and you will see!