Because the cell has a formula it will NEVER be seen by Excel as a blank.

There is probably a way to accomplish what you want, but you'll need to
provide more info if we are to help you

"Robin Krupp" wrote:

I am doing a vlookup where i throwing in a "" if there is an error, what im
trying to do is do a past special and skip blanks but all the values get over
written . excel must be treating the cell as not blank. even after i paste
sepcial values in same row im doing vlookupo and then try it . it still
wants to over write cells where no match was found ... any ideas