I have a sheet where I need to return a start date if the date is between certain dates. Each record has a start date but I want to display the date in another sheet only if it is between September 1st 2012 and 31st August 2013
In one sheet (Data) I have the two dates:
B8 = 1st September 2012
C8 = 31st August 2013
In another sheet (S360) I have the start dates (column AV) along with the rest of the static data including the ID in Column A which I update weekly.
In my master sheet, Column A has the ID for the client and the start date is returned in column X
I have the following which works:
=IF(AND('S360'!AV2>Data!$B$8,'S360'!AV2<Data!$C$8),'S360'!AV2, "")
However, There is a lot of other data which can be filtered and/or sorted in a number of ways with VLOOKUPs. For example:
=IF(ISNA(VLOOKUP(A2,'S360'!$A$2:$AL$2687,6,FALSE)),"",VLOOKUP(A2,'S360'!$A$2:$AL$2687,6,FALSE)) is the Area location of the client and I may filter this alphabetically or by area. When I do this, the data throws up an Inconsistent Formula warning. I am not sure if this is actually a problem but I think it could be.
How can I add a VLOOKUP to the formula so it always shows the correct data?
Thanks in anticipation.
Simon
Bookmarks