tag customers for marketing

D

Dave

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
 
T

Tom Ogilvy

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.
 
D

Dave

Tom Ogilvy said:
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.
Click to expand...
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
 
Top