Not if I have an "if" statement as well. The vlookup is not the problem.
The problem comes when trying to special paste values into another sheet. I
need a blank cell and not an ' showing in the new sheet.
--
suesea


"Peo Sjoblom" wrote:

Never heard of that, if vlookup picks up a blank cell a zero is returned or
if it can't find a match #N/A is returned. Post your formula that returns an
apostrophe


--


Regards,


Peo Sjoblom



"Suesea" wrote in message
...
i have spreadsheet using various vlookups from other sheets. Need to
special
paste values of vlookups in new sheet. If vlookup picks up a blank cell
then
the pasted value on new sheet is showing ' instead of a blank cell. I
need
to have a blank cell and not a label symbol. How do I and on what sheet
do I
change format and which format should I be using? sheet 1 is vlookup
formulas, sheet 2 and 3 is information sheet 1 is looking up. I need the
new
sheet to save as txt file for importing to other program.
--
suesea