This is after I format as "Number" prior to that one is number one is test.

What I'd like to do is find a common ground so this formula will work

"Niek Otten" wrote:

<they both check out as number

Is that number format or is that the result of =ISNUMBER(Sheet4!$A$1) and
ISNUMBER(B4) check? BTW you'll have to check Sheet4!$A$1:Sheet4!$A$2317
Same for the length

<Sheet 4 is sorted 0-9 For column A?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tom" wrote in message
...
I have verified both tables with istext and isnumber. I have copied an
re-pasted as values and formatted those columns as number, they both check
out as number and length 6.

=VLOOKUP(B4,Sheet4!$A$1:$E$2317,3,FALSE) is the formula I am using. B4 is
in the sheet I want to add the information from "Sheet 4 into. Sheet 4 is
sorted 0-9, and the data I want is in column 3.

I found that if I run it thru Access, everything works the way I want it
to
go. But why not in Excel??? I'm baffled

"Niek Otten" wrote:

It should. Check both the search argument and the table entries with
ISTEXT
or ISNUMBER and check the length of both wit LEN().
What is your formula and especially the 4th argument? Is the table sorted
ascending?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tom" wrote in message
...
Didn't work either

"Niek Otten" wrote:

Formatting as numbers afterwards is not enough.
To make the text numbers:

- format as number
- copy an empty cell
- select your "numbers"
- EditPaste Special, check Add

Now they should be numbers

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tom" wrote in message
...
Trying a vlookup formula one set of paroduct numbers has a little
green
triganle in the upper left corner of the cell. The formula returns
our
friend #N/A. I have tried formatting the entires (one is sent as
text,
the
other as general) as text (both) General (both) and as numbers.
There
ae
no
trailing zeros or other odd spaces characters or what not. If I
copy
one
number to the other spreadsheet , it works but when you have several
hundereds of rows, that's not practical.

Any thought on what is problem/fix is here??

Thanx