Nope. The cells are all formatted "general", and the formula bar shows
exactly what's in the cell.
--
Thanks!

Pete.


"Dave Peterson" wrote:

ps.

Make sure that the values contained in the cells are what they're supposed to
be.

Watch out for numbers having a custom number format. Maybe the N only shows up
because of formatting--not because the cell actually contains that N.

What do you see in the formula bar?

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?
--
Thanks!

Pete.

--

Dave Peterson