Extract data with 2 criteria

[marreco]

Hi.
I have a new file with one more criterion.
I need that data extraction also look for the date.
Now I have 3 criteria
1st Go check in "C1" worksheet "Result" and look at sheet "AGENDA"

2nd Go check in "A4", "C4", "E4", "G4", "I4" worksheet "Result" look in worksheet "AGENDA"

3 and also dates "C2" and "C3" worksheet "Result" look in worksheet "AGENDA"
See the file

[Charles]

marreco,

In looking at the worksheet. How would you determine the "First" and "Last" date.

[marreco]

Hi.
Because dates were in "C2" and "C3"
All that is greater than "C2" and less than "C3"

[Charles]

HI,

You want to look in "AGENDA" for the Dates.
How would you determine which Date in that sheet you want in C2 and C3 of the "Result" sheet?

[marreco]

Hi
by I do not know speak English, sometimes I get confused reading.

in this case the sheet "Results" criteria will "C2" and "C3" and then extract the data from "AGENDA"

[Charles]

Hi,

In the sheet "AGENDA" for Raposa you have several Dates in column F. I'm assuming you want these dates to populate the Result sheet C2 and C3.
But, if you look at Column F you have several Dates. Which of these Dates do you want to populate Result?
How would you determine this?

[marreco]

Hi.
Imagine that you are on the "Results" in "C1", you typed "RAPOSA".
Now in "C2", you typed the following date: dd/MM/yyyy (01/11/2012).
And in "C3" You have entered the following data: dd/MM/yyyy (03/11/2012).

then the tab labeled "Results" in "G6" we the Cliente "D", and "I6" we the Cliente "E"

[Charles]

OK,

If I understand what you want you will enter the "Client" and the "Dates" in the "Result" sheet.
You then just want to populate the Result sheet that equals the Client and Date from the Agenda sheet.
Right?

[marreco]

Yes!!

[marreco]

Hi Any idea?

Thank you!!