"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.
--
Thanks!

Pete.


"Gord Dibben" wrote:

What do you mean by C8 is <=N90486 and =N100001

Those are text strings so cannot be <= or =

Where are the formulas entered?


Gord Dibben MS Excel MVP

On Mon, 18 May 2009 14:37:01 -0700, Pete
wrote:

My Excel 2003 workbook includes the following sort of data:

...
N90486 HOND 9 ACO4EXL RED 1HGCS22839A010469
N100001 HOND 10 INSEX RED JHMZE2H73AS001296
...

VLOOKUP is using the first column to pull data (=VLOOKUP(C8,inventory,4)).
If the value in C8 is <=N90486, the data transfers fine; if it is =N100001,
it returns #N/A and does not offer the "Formula Error Button" next to the
cells with errors.

Suggestions?