The cells you are double-clicking probably are text values that look like
numbers.

Try copying a single blank cell, selecting all the values in that column,
then using
Edit-Paste Special-VAlues-Add

"san-avsc" wrote:

I can't get my vlookup formula to recognize an equal value in another column
unless I double-click on the cell that contains the value that I'm looking
for in the other column. For one or two cells, that's not a big deal, but for
a few hundred cells at a time...