my w/sheet1 data looks like this.
Col A--------------------ColB--------------------ColC
SalesMan---------------Date--------------------Amount
Raj -------------------01/Mar/09---------------500.00
Jones-----------------01/Mar/09---------------235.oo
Mary------------------02/Mar/09---------------190.00
Mary------------------03/Mar/09---------------100.00
Raj--------------------03/Mar/09---------------290.00
Cathy-----------------04/Mar/09---------------400.00
Raj--------------------30/Mar/09---------------500.00
Jones------------------30/Mar/09---------------450.00
Raj---------------------01/Apr/09---------------100.00
Mary-------------------02/Apr/09---------------450.00
the list goes on.........
output on w/sheet2 be looks like this:
Col A--------------------------Col B(drop down lists in cell a1 and B1)
Mary--------------------------Mar-09
Date--------------------------Amount
02/Mar-09--------------------190.00
03/Mar/09--------------------100.00

"TUNGANA KURMA RAJU" wrote:

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.