I need a function/formula to extract a list of values from a list basing on
two conditions.
I have date wise sales data sales person,date,amount in sheet 1.
In sheet2, if I enter Sheet2!a1=name of salesman and in cell
B2=month-year(I have drop down list viz.salesmem list,month-year list.)
I need date wise sales details of that salesman , of the specified
month, to the w/sheet range A2:B32.