vlookup failure

[wandap]

While doing a vlookup with an excel 2000 worksheet (that
started as Excel Comma Separated Value but is now saved
as Excel 2000) with another excel 2000 worksheet, my
answer from the vlookup is not completed for all the
cells in question. Why would it only work for 8% of the
items requested when both worksheets have similar cell
formats.

Before adding SR-1 Premium to Excel 2000 the above
attempt to do the same vlookup resulted in the vlookup
function equation as the answer. Vlookup didn't work at
all.

 

[Frank Kabel]

Hi
probably different formats (e.g. numbers versus Textformat, etc.). So
both cells have to be IDENTICAL. You can alsways test this with a
formula like
=A1=C10
this should return if you expect that A1 and C10 are identical