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?