Formulas can return data but they cannot delete data.

You would need VBA, probably event code to clear cells.


Gord Dibben MS Excel MVP

On Tue, 13 Nov 2007 09:42:03 -0800, LiveUser
wrote:

I am using vlookup to find accounts from sheet1. What ever vlookup finds I
want to delete off sheet1. Any ideas?

Thank you.