jonathan92591
Board Regular
- Joined
- Oct 27, 2011
- Messages
- 65
Hello everyone,
How to have Excel look up data and apply to multiple formulas
--
Excel or Access version: Excel 2010
Computer operating system: Windows XP
Sample data: See below
Formula(s) right now: = SMALL(Data!A2:A99,1) = MATCH(A2,Data!$1:$1,0)
Current result(s): 7/3/2009 1
My goal: I'd like to have the formulas in my sheet, look at the "data" sheet to grab the data and do the formula so I can make this process go faster. So like, =sum() looks for ID56 column, etc. Not sure if I'm making sense. Sorry.
Error message: No error message
How error occurred: No error message
Generated in: Excel
Thank you.
JT
My data sheet will have 100s of these:
Any my drill down sheet for each one will look like this:
Thank you!
JT
How to have Excel look up data and apply to multiple formulas
--
Excel or Access version: Excel 2010
Computer operating system: Windows XP
Sample data: See below
Formula(s) right now: = SMALL(Data!A2:A99,1) = MATCH(A2,Data!$1:$1,0)
Current result(s): 7/3/2009 1
My goal: I'd like to have the formulas in my sheet, look at the "data" sheet to grab the data and do the formula so I can make this process go faster. So like, =sum() looks for ID56 column, etc. Not sure if I'm making sense. Sorry.
Error message: No error message
How error occurred: No error message
Generated in: Excel
Thank you.
JT
My data sheet will have 100s of these:
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | SOS/ASS100321 | Other Signups | ASD100804 | Other Signups | ||
2 | 5/15/2009 | 1 | 8/29/2009 | 2 | ||
3 | 5/21/2009 | 1 | 11/4/2009 | 1 | ||
4 | 6/3/2009 | 1 | 11/18/2009 | 1 | ||
5 | 6/8/2009 | 2 | 12/30/2009 | 1 | ||
6 | 6/23/2009 | 1 | 1/29/2010 | 1 | ||
7 | 6/25/2009 | 1 | 2/10/2010 | 1 | ||
8 | 6/26/2009 | 1 | 2/12/2010 | 1 | ||
9 | 6/29/2009 | 2 | 2/15/2010 | 1 | ||
10 | 6/30/2009 | 2 | 2/22/2010 | 1 | ||
11 | 7/2/2009 | 2 | 3/8/2010 | 1 | ||
12 | 7/3/2009 | 1 | 3/25/2010 | 1 | ||
13 | 7/7/2009 | 1 | 3/29/2010 | 1 | ||
Data |
Any my drill down sheet for each one will look like this:
Excel Workbook | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | * | * | * | * | * | * | * | * | * | * | * | ||
2 | SOS/ASS100321 | ||||||||||||
3 | * | * | * | * | * | * | * | * | * | * | * | ||
4 | Dates | * | * | Months Out | * | * | |||||||
5 | Start | 5/15/2009 | 1 | * | Out | Month | Purchases | % of Total | Rank | * | * | ||
6 | End | 3/22/2010 | * | * | 11 | May-09 | 2 | 1% | 9 | * | * | ||
7 | * | * | * | * | 10 | Jun-09 | 10 | 5% | 7 | * | * | ||
8 | Sale Range | * | * | 9 | Jul-09 | 13 | 7% | 6 | * | * | |||
9 | Days | 311 | * | * | 8 | Aug-09 | 8 | 4% | 8 | * | * | ||
10 | Weeks | 45 | 7.0 | * | 7 | Sep-09 | 13 | 7% | 6 | * | * | ||
11 | Months | 11 | 31 | * | 6 | Oct-09 | 20 | 11% | 4 | * | * | ||
12 | * | * | * | * | 5 | Nov-09 | 8 | 4% | 8 | * | * | ||
13 | * | * | * | * | 4 | Dec-09 | 22 | 12% | 3 | * | * | ||
14 | * | * | * | * | 3 | Jan-10 | 42 | 23% | 1 | * | * | ||
15 | * | * | * | * | 2 | Feb-10 | 26 | 14% | 2 | * | * | ||
16 | * | * | * | * | 1 | Mar-10 | 18 | 10% | 5 | * | * | ||
17 | * | * | * | * | * | Total | 182 | * | * | * | * | ||
18 | * | * | * | * | * | * | * | * | * | * | * | ||
19 | * | * | * | * | * | * | * | * | * | * | * | ||
20 | * | * | * | * | * | * | * | * | * | * | * | ||
21 | * | * | * | * | * | * | * | * | * | * | * | ||
22 | * | * | * | * | * | * | * | * | * | * | * | ||
23 | * | * | * | * | * | * | * | * | * | * | * | ||
24 | * | * | * | * | * | * | * | * | * | * | * | ||
25 | * | * | * | * | * | * | * | * | * | * | * | ||
26 | * | * | * | * | * | * | * | * | * | * | * | ||
27 | * | * | * | * | * | * | * | * | * | * | * | ||
28 | * | * | * | * | * | * | * | * | * | * | * | ||
29 | * | * | * | * | * | * | * | * | * | * | * | ||
30 | * | * | * | * | * | * | * | * | * | * | * | ||
31 | * | * | * | * | * | * | * | * | * | * | * | ||
32 | * | * | * | * | * | * | * | * | * | * | * | ||
33 | * | * | * | * | * | * | * | * | * | * | * | ||
SOSASS100321 |
Thank you!
JT