Sorry, I didn't explain it well. I'm not actually typing "=" or "<="; I'm
entering a stock number up to and including N90486, or N100001 or above.
Only when (and every time) I enter N100001 or above do I get "#N/A" in all of
my VLOOKUP cells.
--
Thanks!

Pete.


"Gord Dibben" wrote:

I know what the operators signify.

I just don't understand how a text string can be < or anything


Gord

On Mon, 18 May 2009 15:56:00 -0700, Pete
wrote:

"less than or equal to" or "more than or equal to".

I have stock numbers from N90001 up to N90486 (so far), and all of them pull
up the data properly; I also have N100001 up to N100008 (again, so far), and
none of them work.