preserving data when using IF statements to compare cells then do a vlookup

  • Hello

    i am using an IF statement to compare the Values of two cells and if they match performing a Vlookup.

    Part of the reason i am doing this is because i am running a report on a weekly basis but want to keep a running total of hoe many times a person does a particular thing.

    the columns have dates at the top and the IF statement compares a call on another sheet with a dat that corresponds to the date at the top of one of the columns, if it matches it does a Vlookup to input the count of how many of X a person has done that week.

    The problem i have is that whilst this works. as soon as the date in the Cell changes the IF statement fails and the data disappears is there anyway of keeping it?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!