I want to tag customers in a prospect list from a current customer list
so I don't send advertising to current customers only prospect

Put in a formula in an adjacent cell the tags the customers

if F2 as an example
=if(D2<DateSerial(Year(Today())-1,Month(Today()),1),"Send To","Don't Send
To")

Then drag fill down the column for as long as you have data.

Obviously the condition of checking the date in Column D against a date a
year prior to today is notional and would be replaced with the conditions
that identify the data in a row as a current customer.
--
Regards,
Tom Ogilvy


"Dave" wrote in message
...
I want to tag customers in a prospect list from a current customer list
so I don't send advertising to current customers only prospect

"Tom Ogilvy" wrote:

Put in a formula in an adjacent cell the tags the customers

if F2 as an example
=if(D2<DateSerial(Year(Today())-1,Month(Today()),1),"Send To","Don't Send
To")

Then drag fill down the column for as long as you have data.

Obviously the condition of checking the date in Column D against a date a
year prior to today is notional and would be replaced with the conditions
that identify the data in a row as a current customer.
--
Regards,
Tom Ogilvy


"Dave" wrote in message
...
I want to tag customers in a prospect list from a current customer list
so I don't send advertising to current customers only prospect

Thanks for responding
But there are no dates invoulved
I have a worksheet of current customers and a worksheet of prospect.
I want to lookup my current list and compair to prospect so I don't do a
mailer to current customers
I don't know if or how to do a lookup function for characters
Thanks
Dave