Doing a VLOOKUP between two worksheets and I enter the formula I need in cell
D2 and reference cell A2 as what I want to lookup. The result comes back fine
(result=John Smith) and I drag it down to the cells beneath it.

However, the result in all of the cells beneath it are the same as the
result I've received in cell D2, John Smith. I am not using $ in my formula
and when you look at the formula in the cells beneath, the reference cell is
changing commensurately, i.e., A3, A4, A5, etc. The results should definitely
be different.

Can anyone help me figure out why this is happening?