Extract data with 2 criteria

[Charles]

Hi,

Sorry I was side tracked.
As for the dates. What if 1 date is missing?
Will the dates that you specify be in the "Agenda" sheet?

[Charles]

Hi,

Here's the file. I left the dates that I used in place.
I did not fully test.

[marreco]

Hi Charles

I'm trying to change your code to fetch the column Lápis.
Enjoy what is ready to put the Lápis.

and am having trouble on the dates

[Charles]

Hi,

I'd like to help, but you need to tell me what your trying to do.
In the code I see you have "c" and "d" doing the same thing.

[marreco]

Hi.
has a down arrow, I need to return the data for the value that is in "C1" and also by date (equal and maoir) -> "E1" and "G1" <- (equal and smaller)

I got back when "C1" has the value "CASA"
but other values {Computador, Familia, Lápis} I can not return.,

[Charles]

Hi,

Check your Date range. The Dates in Casa falls with in your range in C1 and E1 and the others do not.
Thats why Casa works.

[marreco]

Hi.

I realized that this format is reading
Date = MM / dd / yyy

I need that law in this format
Date = DD / mm / yyy

[Charles]

It's not the format of the dates its the date range.
The dates in the other than Casa do not fall with in the specified dates.

[marreco]

Hi.
but because when I change from "E1" and "G1" I get back "Pencil" and others?

[Charles]

Hi,

Your problem is with the dates.
The Dates that you have in "Casa" is ok.
The Dates you have in "Raposa" are not ok.
The date you have in E1 of PROGRAMAÇÃO is


11/4/2012

and the dates in Raposa is


11/3/2012
10/10/2012
10/11/2012
11/1/2012
11/2/2012
12/18/2012
11/3/2012
11/3/2012
11/3/2012
11/3/2012

As you can see the list of dates are not >= 11/4/2011.

Thats why when you run the code it does not copy any thing to the Program sheet.

The Dates for Casa" are


11/2/2012
11/1/2012
11/5/2012
11/3/2012
11/2/2012
11/8/2012
11/4/2012
11/5/2012
11/6/2012
11/7/2012

And as you can see you have several Dates that are >= 11/4/2012.

There for the code will show the data in the Programe sheet.

I hope tis helps you.