T
TheBigStig
I have 3 worsheets on a file.
Number one contains a list of current customers by:
Column 1: Account number, Column 2: Company Name, Column 3: Adress Line 1,
Column 4: City, Column 5: Zip/Postal Code and Column 6: Spend to date.
Number 2 is an import table that I paste to each month with the following
data supplied by my head office:
Column 1: Account Number, Column 2: Company, Column 3: Spend to date.
The idea was to be able to then use a VLOOKUP formula to go back to
Worksheet one and sort customer spend by zip/postcode area.
The VLOOKUP formula I use for this is:
=IF(ISNA(VLOOKUP(A2,Special,5,FALSE)),"No
Spend",(VLOOKUP(A2,Special,5,FALSE))).
NOW: I want a third worksheet to tell me if there are any NEW customers on
the list being sent by my head office that I didn't originally have listed on
worksheet 1.
This way, I can add them manually to worksheet 1 ready for next month and
then the third worksheet will do the same again!
Is this possible with a formula and can anyone tell me what it is and how to
do it?!!
Thank you in advance!
Number one contains a list of current customers by:
Column 1: Account number, Column 2: Company Name, Column 3: Adress Line 1,
Column 4: City, Column 5: Zip/Postal Code and Column 6: Spend to date.
Number 2 is an import table that I paste to each month with the following
data supplied by my head office:
Column 1: Account Number, Column 2: Company, Column 3: Spend to date.
The idea was to be able to then use a VLOOKUP formula to go back to
Worksheet one and sort customer spend by zip/postcode area.
The VLOOKUP formula I use for this is:
=IF(ISNA(VLOOKUP(A2,Special,5,FALSE)),"No
Spend",(VLOOKUP(A2,Special,5,FALSE))).
NOW: I want a third worksheet to tell me if there are any NEW customers on
the list being sent by my head office that I didn't originally have listed on
worksheet 1.
This way, I can add them manually to worksheet 1 ready for next month and
then the third worksheet will do the same again!
Is this possible with a formula and can anyone tell me what it is and how to
do it?!!
Thank you in advance!