If data is returned then delete data
 

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

Thank you.

If data is returned then delete data
 

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.