VLookup Question

[boingman7777]

I'm currently trying to use a macro to look up data associated with a particular date (from pull down bars)

ex. I have data of attendance ranging from Sept 1st to September 30th...

If I use pull down bars to select "September" --> "15th", how can I have excel automatically display "3000 people".

I use VLookup right?

Thanks!

 

[jbeaucaire]

I would use either COUNTIF:

Excel Workbook
	A	B	C	D	E
1	Name	Date		Date to Check	People
2	Name1	3/1/2009		3/1/2009	4
3	Name2	3/1/2009
4	Name3	3/1/2009
5	Name4	3/1/2009
6	Name5	3/5/2009
7	Name6	3/6/2009
8	Name7	3/7/2009
9	Name8	3/8/2009
10	Name9	3/9/2009
11	Name10	3/10/2009
12	Name11	3/11/2009
13	Name12	3/12/2009
14	Name13	3/13/2009
15	Name14	3/14/2009
16	Name15	3/15/2009
17	Name16	3/16/2009
18	Name17	3/17/2009
19	Name18	3/18/2009
20	Name19	3/19/2009
Sheet2

 

[Norie]

Where does the 3000 come from?

VLOOKUP will only return one value, if you want to get totals for particular dates or periods you'll need something else, perhaps the suggested COUNTIF.