Re: $$Excel-Macros$$ lookup based on multiple dates.

Hi, please see the attachment. On Mon, Dec 3, 2012 at 8:10 PM, AK wrote: > Hi All, > > I have a question, looking for solution through formula (but VBA is fine > if not possible through formula :) )...I have 2 sheets in a workbook i.e > "Cust data" and "Review"... > > > In the Cust data s

Re: $$Excel-Macros$$ lookup based on multiple dates.

Try something like this COUNTIFS(Review!A:A,'Cust data'!A2,Review!B:B,">=#"&'Cust data'!B2&"#",Review!B:B,"<=#"&'Cust data'!C2&"#") On Mon, Dec 3, 2012 at 8:10 PM, AK wrote: > Hi All, > > I have a question, looking for solution through formula (but VBA is fine > if not possible through formul

$$Excel-Macros$$ lookup based on multiple dates.

Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through formula :) )...I have 2 sheets in a workbook i.e "Cust data" and "Review"... In the Cust data sheet I have start date of the project i.e column B, column C is First review date and Column D i