Trying to do a vlookup, but am getting N/A. Formats are the same on each
sheet, which is general, even though some of the lookup values appear as
numbers and some are text.
--
David

Hi

Both lots must be the same format. If you want to turn your text into
numbers, copy a blank unused cell, select your range and then Edit/Paste
Special/Add

Hope this helps.
Andy.

"David" wrote in message
...
Trying to do a vlookup, but am getting N/A. Formats are the same on each
sheet, which is general, even though some of the lookup values appear as
numbers and some are text.
--
David

Both are text, I tried to make the numbers formatted to numbers, but that did
not make a difference. It appears that it is the numbers that are giving me
me trouble. I think the application that the worksheet came from may be part
of the problem, because formatting is difficult. I have to format things
twice to make them work, for example dates that appear as numbers do not
easily format as dates by using format painter. Just some engineer giving us
a hard time, stayed up too late the night before, lol. Microsoft does the
same thing making many of their dialog boxes modal with out purpose.
--
David


"AndyB" wrote:

Hi

Both lots must be the same format. If you want to turn your text into
numbers, copy a blank unused cell, select your range and then Edit/Paste
Special/Add

Hope this helps.
Andy.

"David" wrote in message
...
Trying to do a vlookup, but am getting N/A. Formats are the same on each
sheet, which is general, even though some of the lookup values appear as
numbers and some are text.
--
David