Simply formatting the cells as Number or General is not sufficient if Excel
believes they are text.

Select an empty cell formatted as Number and EditCopy.

Select your range of data and Paste SpecialAddOKEsc to coerce the data to
Numbers.


Gord Dibben MS Excel MVP


On Thu, 6 Apr 2006 06:36:44 -0500, alisyed
wrote:


I'm using a simple vlookup. The values I want results for (on the very
left of my array) apparently do not have the same format as the ones I
am looking up.

If I want them to produce a result, I have to copy and paste as a value
in the array and only then will my vlookup will work.

It's not a formatting issue - because I've checked formats and they're
both General.

Is there a way to make them comparable? Any help would be greatly
appreciated.

Gord Dibben MS Excel MVP