Auto populating notes?

[Pizzio]

I'm trying to come up with a formula where if 'lease 1' has a variance of 10% or greater then the formula would list ALL the variance reasons. See below column I for what I'm hoping to return with.

Thank you in advance.

Nick

test.xls
	B	C	D	E	F	G	H	I	J
1	2009RATBudgetvs.Actual(CurrentMonth)		DollarVariance
2	Region	Market	Budget$	Actual$	Variance	Variance%	VarianceRank	Hownotesshouldcomeout
3	Central	RCHI	134,320	52,866	81,454	61%	1	Lease1hadnoexpenseincurrentmonth,Lease3cameinunderbudget,Lease4hadunbudgeteddollarsof$10k
4	CentralTotal		134,320	52,866	81,454	61%
5
6	2009DetailbyLeaseID
7	FINALCategory	FINALSubCategory	2009.Jan	2009.Jan	Variance
8	RCHI	1	90,022	-	(90,022)	($90k)
9	RCHI	2	28,344	28,344	-
10	RCHI	3	14,319	12,887	(1,432)	($1.4k)
11	RCHI	4	-	10,000	10,000	$10k
12	RCHI	5	1,635	1,635	-
13	RCHI	6	-	-	-
14	RCHITotal		134,320	52,866	(81,454)
15
16	VarianceExplanationslist
17	hadnoexpenseincurrentmonthgeneratingvarianceof
18	cameinunderbudgetby
19	hadunbudgeteddollarsof
Central

 

[Pizzio]

Is something like this possible?

 

[Pizzio]

If this isn't exactly possible can anyone come up with a work around?

 

[Pizzio]

Is something like this possible?

?

 

[lenze]

To get an answer, you need to be MORE specific as to what you want. Give details. I personally can't see what you want or need!!

lenze

 

[Pizzio]

I'm looking for a formula that if there is a market variance greater or less than 10% it would look at the detail for the market and where I've populated a $ value in column G it auto-populates variance notes (starting in B17). The output i'm hoping to achieve in cell I3 is the following: Lease 1 had no expense in current month, Lease 3 came in under budget, Lease 4 had unbudgeted dollars of $10k. if it isn't possible to have a notes reference table PLUS incorporate the dollar value of the variance i'm up for suggestions. I just need a formula that lists every lease that has a variance and why.

Thank you!