software

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.--
alisyed
------------------------------------------------------------------------
alisyed's Profile: www.excelforum.com/member.php...oamp;userid=33226
View this thread: www.excelforum.com/showthread...hreadid=530448
Is there a reason you would not simply Copy the whole column, and Paste
Special, Values back over itsself?

ie, is the array changeable? - and if so how is the data created?

--

alisyed Wrote:
gt; I'm using a simple vlookup. The values I want results for (on the very
gt; left of my array) apparently do not have the same format as the ones I
gt; am looking up.
gt;
gt; If I want them to produce a result, I have to copy and paste as a value
gt; in the array and only then will my vlookup will work.
gt;
gt; It's not a formatting issue - because I've checked formats and they're
gt; both General.
gt;
gt; Is there a way to make them comparable? Any help would be greatly
gt; appreciated.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=530448
I had a similar problem just today. The value I was looking up was
formatted as text - even though Excel indicated it was a number in the
Formatgt;gt;Cells menu.

There is probably a simpler way to fix the problem...but I used a
working cell =VALUE(CellReference) and used that cell for the vlookup
instead...

Hope this helps. But yes....the common sense approach is copy/paste
values....wish I had thought of that

/systematic--
systematic
------------------------------------------------------------------------
systematic's Profile: www.excelforum.com/member.php...oamp;userid=25294
View this thread: www.excelforum.com/showthread...hreadid=530448
yeah, i cant just copy and paste as values since the data is not in the
same order...--
alisyed
------------------------------------------------------------------------
alisyed's Profile: www.excelforum.com/member.php...oamp;userid=33226
View this thread: www.excelforum.com/showthread...hreadid=530448Simply formatting the cells as Number or General is not sufficient if Excel
believes they are text.

Select an empty cell formatted as Number and Editgt;Copy.

Select your range of data and Paste Specialgt;Addgt;OKgt;Esc to coerce the data to
Numbers.Gord Dibben MS Excel MVPOn Thu, 6 Apr 2006 06:36:44 -0500, alisyed
gt; wrote:

gt;
gt;I'm using a simple vlookup. The values I want results for (on the very
gt;left of my array) apparently do not have the same format as the ones I
gt;am looking up.
gt;
gt;If I want them to produce a result, I have to copy and paste as a value
gt;in the array and only then will my vlookup will work.
gt;
gt;It's not a formatting issue - because I've checked formats and they're
gt;both General.
gt;
gt;Is there a way to make them comparable? Any help would be greatly
gt;appreciated.

Gord Dibben MS Excel MVP