tomdabom76
New Member
- Joined
- Oct 10, 2006
- Messages
- 10
Hey everyone,
This is my first post in this forum. I am using Windows XP and Excel 2002. The following are the tables that I am working with. I am trying to set up an array lookup that will work even as dates are added. I have tried an index function with match functions to try and get this to work, but no success. What I would like to do for example is search the whole range for Zelda on 10/1/06 and get the appropriate number of downloads. I hope this is clear. Thanks in advance for your help
This is my first post in this forum. I am using Windows XP and Excel 2002. The following are the tables that I am working with. I am trying to set up an array lookup that will work even as dates are added. I have tried an index function with match functions to try and get this to work, but no success. What I would like to do for example is search the whole range for Zelda on 10/1/06 and get the appropriate number of downloads. I hope this is clear. Thanks in advance for your help
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Zelda | |||||
2 | Date | Downloads | ||||
3 | 10/1/2006 | 5 | ||||
4 | 10/2/2006 | 10 | ||||
5 | ||||||
6 | SuperMario | |||||
7 | Date | Downloads | ||||
8 | 10/1/2006 | 5 | ||||
Sheet1 |