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: http://www.excelforum.com/member.php...o&userid=33226
View this thread: http://www.excelforum.com/showthread...hreadid=530448