]How to have Excel look up data and apply to multiple formulas

[jonathan92591]

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:

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