EXCEL HELP...

In Column M, calculate the Realty Company from the lookup table in cells P3:Q7. In cell P3, change the Realty Name to your last name Realty (i.e. Davis Realty). Use the VLOOKUP command to calculate. (Hint: explore the fourth component of the VLOOKUP function.) So, home with square footage from:

0 to less than 1200 feet, go to (Your Name) Realty

1200 to less than 1800 feet, go to Elmo Homes

1800 to less than 2500 feet, go to Borat Homes

2500 to less than 3000 feet, go to Soprano Builders

Homes with 3000 feet or more, go to Sunshine Developers

Listing ID	Asking Price	Square Feet	Age	Tax Percentage	Annual Tax	Sales Price	Style	Bedroom	Bath	Date Listed	Date Sold	Realty Company			Lookup Table:
101	$ 87,400	1,236	3	.00125	$ 97.19	$ 77,750	Condo	2	1	11/22/2009	4/14/2010				Square Footage	Realty Company
102	$ 110,900	1,740	4	.00125	$ 131.56	$ 105,250	Victorian	2	1.5	8/23/2009	6/20/2010				0	Hason Realty
103	$ 95,000	1,715	4	.00125	$ 118.75	$ 95,000	Ranch	2	1.5	5/18/2010	5/22/2010				1200	Elmo Homes
104	$ 87,000	1,273	4	.00125	$ 102.19	$ 81,750	Condo	2	1	9/30/2009	5/12/2010				1800	Borat Realty
105	$ 73,900	970	4	.00125	$ 79.38	$ 63,500	Victorian	1	0.5	2/7/2010	4/24/2010				2500	Soprano Builders
106	$ 77,000	900	5	.00125	$ 84.69	$ 67,750	Victorian	1	0.5	6/21/2009	5/14/2010				3000	Sunshine Developers
107	$ 133,000	1,850	5	.00125	$ 144.38	$ 115,500	Ranch	2	1.5	3/2/2010	5/16/2010
108	$ 116,000	1,720	5	.00125	$ 124.69	$ 99,750	Ranch	2	1.5	3/18/2010	4/23/2010
109	$ 102,000	1,606	5	.00125	$ 128.75	$ 103,000	Ranch	2	1.5	8/5/2009	5/29/2010
110	$ 94,000	1,305	5	.00125	$ 110.31	$ 88,250	Victorian	2	1.5	6/20/2009	5/25/2010
111	$ 112,900	1,700	6	.00125	$ 143.75	$ 115,000	Condo	2	1.5	2/4/2010	4/8/2010
112	$ 105,000	1,620	6	.00125	$ 132.50	$ 106,000	Condo	2	1.5	6/27/2009	5/3/2010
113	$ 104,500	1,630	6	.00125	$ 122.50	$ 98,000	Condo	2	1.5	7/22/2009	4/2/2010
114	$ 103,000	1,540	6	.00125	$ 113.13	$ 90,500	Ranch	2	1.5	3/24/2010	6/12/2010
115	$ 87,200	1,229	6	.00125	$ 108.75	$ 87,000	Ranch	2	1	1/23/2010	6/26/2010
116	$ 97,500	1,500	7	.00125	$ 103.44	$ 82,750	Ranch	2	1.5	6/28/2009	4/16/2010
117	$ 100,000	1,535	7	.00125	$ 113.75	$ 91,000	Victorian	2	1.5	5/9/2009	4/28/2010
118	$ 92,000	1,415	7	.00125	$ 113.75	$ 91,000	Ranch	2	1.5	7/6/2009	4/24/2010
119	$ 86,900	1,165	7	.00125	$ 110.63	$ 88,500	Victorian	2	1	8/10/2009	5/15/2010
120	$ 76,600	1,200	7	.00125	$ 85.00	$ 68,000	Condo	2	1	5/7/2009	5/1/2010
121	$ 105,000	1,920	8	.00125	$ 119.38	$ 95,500	Ranch	2	1.5	4/27/2010	5/14/2010
122	$ 94,500	1,580	9	.00125	$ 119.06	$ 95,250	Victorian	2	1.5	4/5/2010	6/15/2010
123	$ 97,500	1,739	13	.0015	$ 127.13	$ 84,750	Victorian	2	1.5	5/10/2010	6/21/2010
124	$ 70,000	1,505	14	.0015	$ 105.75	$ 70,500	Condo	2	1.5	3/15/2010	5/30/2010
125	$ 60,000	1,198	14	.0015	$ 76.50	$ 51,000	Ranch	2	1	3/8/2010	5/9/2010
126	$ 158,000	2,563	14	.0015	$ 239.25	$ 159,500	Victorian	3	2.5	11/19/2009	6/11/2010
127	$ 58,000	1,051	15	.0015	$ 87.00	$ 58,000	Ranch	2	1	12/5/2009	5/17/2010
128	$ 169,500	3,750	19	.0015	$ 247.50	$ 165,000	Victorian	4	2.5	3/14/2010	5/30/2010
129	$ 78,000	1,080	21	.0015	$ 102.75	$ 68,500	Victorian	2	1	1/9/2010	4/2/2010
130	$ 54,000	1,142	21	.0015	$ 77.63	$ 51,750	Victorian	2	1	10/11/2009	5/5/2010
131	$ 107,000	1,464	22	.0015	$ 160.50	$ 107,000	Victorian	2	1.5	12/22/2009	5/25/2010
132	$ 210,000	2,116	25	.0015	$ 292.88	$ 195,250	Victorian	3	2	9/1/2009	6/20/2010
133	$ 66,000	1,159	25	.0015	$ 93.75	$ 62,500	Ranch	2	1	9/13/2009	6/13/2010
134	$ 72,500	1,280	38	.0015	$ 105.38	$ 70,250	Victorian	2	1	3/1/2010	5/4/2010
135	$ 93,900	1,428	40	.0015	$ 123.75	$ 82,500	Victorian	2	1.5	10/3/2009	5/23/2010
136	$ 82,000	1,375	40	.0015	$ 124.13	$ 82,750	Victorian	2	1.5	5/17/2009	5/6/2010
137	$ 62,000	1,480	40	.0015	$ 89.25	$ 59,500	Ranch	2	1.5	9/11/2009	5/20/2010
138	$ 184,400	2,250	40	.0015	$ 273.75	$ 182,500	Condo	3	2	11/4/2009	5/21/2010
139	$ 69,900	1,400	45	.0015	$ 91.13	$ 60,750	Ranch	2	1.5	3/10/2010	4/10/2010
140	$ 156,000	1,920	1	.00125	$ 167.50	$ 134,000	Ranch	2	1.5	12/29/2009	4/28/2010
141	$ 144,900	1,710	1	.00125	$ 179.06	$ 143,250	Victorian	2	1.5	4/16/2010	6/2/2010
142	$ 180,000	2,774	2	.00125	$ 206.88	$ 165,500	Victorian	3	2.5	12/10/2009	4/5/2010
143	$ 215,000	2,921	3	.00125	$ 268.75	$ 215,000	Victorian	3	2.5	11/17/2009	5/6/2010
144	$ 75,500	1,275	3	.00125	$ 96.25	$ 77,000	Condo	2	1	10/10/2009	4/1/2010
145	$ 199,900	2,580	4	.00125	$ 234.69	$ 187,750	Ranch	3	2.5	6/30/2009	4/18/2010
146	$ 190,000	2,580	4	.00125	$ 213.75	$ 171,000	Victorian	3	2.5	9/2/2009	4/22/2010
147	$ 137,500	1,837	4	.00125	$ 171.88	$ 137,500	Victorian	2	1.5	4/16/2009	4/7/2010
148	$ 215,000	2,848	4	.00125	$ 241.88	$ 193,500	Ranch	3	2.5	12/25/2009	5/30/2010
149	$ 75,000	1,338	4	.00125	$ 95.63	$ 76,500	Ranch	2	1.5	4/8/2010	5/15/2010
150	$ 75,900	997	4	.00125	$ 93.75	$ 75,000	Ranch	1	0.5	6/13/2009	6/2/2010
151	$ 87,000	1,280	5	.00125	$ 108.75	$ 87,000	Victorian	2	1	1/23/2010	6/27/2010
152	$ 85,500	1,900	5	.00125	$ 101.25	$ 81,000	Ranch	2	1.5	7/4/2009	6/1/2010
153	$ 215,000	2,664	6	.00125	$ 265.94	$ 212,750	Victorian	3	2.5	9/20/2009	6/13/2010
154	$ 87,500	1,173	6	.00125	$ 109.38	$ 87,500	Victorian	2	1	8/29/2009	5/27/2010
155	$ 81,000	1,365	6	.00125	$ 102.19	$ 81,750	Ranch	2	1.5	6/29/2009	6/23/2010
156	$ 75,000	1,030	6	.00125	$ 87.19	$ 69,750	Ranch	2	1	11/19/2009	5/28/2010
157	$ 88,900	1,549	7	.00125	$ 96.56	$ 77,250	Condo	2	1.5	6/4/2009	5/4/2010
158	$ 80,500	1,258	7	.00125	$ 93.44	$ 74,750	Victorian	2	1	4/16/2010	5/27/2010
159	$ 127,000	1,880	8	.00125	$ 158.75	$ 127,000	Ranch	2	1.5	7/27/2009	4/29/2010
160	$ 208,000	2,600	10	.0015	$ 268.13	$ 178,750	Victorian	3	2.5	8/4/2009	4/29/2010
161	$ 145,000	2,150	10	.0015	$ 219.38	$ 146,250	Victorian	3	2	11/2/2009	6/1/2010
162	$ 89,000	1,746	10	.0015	$ 115.88	$ 77,250	Condo	2	1.5	2/4/2010	4/13/2010
163	$ 61,900	837	10	.0015	$ 79.50	$ 53,000	Condo	1	0.5	2/5/2010	6/20/2010
164	$ 130,000	2,000	11	.0015	$ 175.50	$ 117,000	Victorian	2	2	5/15/2010	5/25/2010
165	$ 83,500	1,560	11	.0015	$ 109.88	$ 73,250	Ranch	2	1.5	8/13/2009	5/13/2010
166	$ 99,500	1,725	12	.0015	$ 147.75	$ 98,500	Condo	2	1.5	2/25/2010	4/12/2010
167	$ 205,000	2,650	13	.0015	$ 267.38	$ 178,250	Victorian	3	2.5	1/9/2010	6/21/2010
168	$ 97,500	1,430	13	.0015	$ 148.88	$ 99,250	Victorian	2	1.5	5/19/2009	4/5/2010
169	$ 92,500	1,050	13	.0015	$ 117.75	$ 78,500	Ranch	2	1	5/4/2010	6/19/2010
170	$ 105,000	1,680	13	.0015	$ 152.63	$ 101,750	Ranch	2	1.5	4/26/2009	4/6/2010
171	$ 67,000	1,350	13	.0015	$ 102.38	$ 68,250	Condo	2	1.5	9/23/2009	5/6/2010
172	$ 123,500	1,894	14	.0015	$ 185.25	$ 123,500	Ranch	2	1.5	7/27/2009	5/15/2010
173	$ 97,500	1,360	14	.0015	$ 146.25	$ 97,500	Condo	2	1.5	5/25/2009	4/1/2010
174	$ 92,200	1,326	14	.0015	$ 121.50	$ 81,000	Victorian	2	1.5	4/20/2010	6/20/2010
175	$ 123,900	1,706	14	.0015	$ 165.38	$ 110,250	Ranch	2	1.5	5/10/2010	5/13/2010
176	$ 120,000	1,948	14	.0015	$ 180.00	$ 120,000	Condo	2	1.5	10/1/2009	4/3/2010
177	$ 79,900	1,314	14	.0015	$ 105.38	$ 70,250	Condo	2	1.5	2/23/2010	4/2/2010
178	$ 125,000	2,150	15	.0015	$ 185.63	$ 123,750	Ranch	3	2	1/6/2010	5/25/2010
179	$ 111,000	1,630	15	.0015	$ 149.63	$ 99,750	Victorian	2	1.5	7/13/2009	4/25/2010
180	$ 99,500	1,500	15	.0015	$ 149.25	$ 99,500	Victorian	2	1.5	5/11/2010	5/29/2010
181	$ 70,000	1,215	15	.0015	$ 101.63	$ 67,750	Ranch	2	1	8/28/2009	4/15/2010
182	$ 73,000	1,027	15	.0015	$ 106.13	$ 70,750	Victorian	2	1	11/18/2009	6/16/2010
183	$ 69,000	1,348	15	.0015	$ 105.38	$ 70,250	Victorian	2	1.5	2/6/2010	6/4/2010
184	$ 115,500	1,767	16	.0015	$ 155.63	$ 103,750	Condo	2	1.5	7/28/2009	5/31/2010
185	$ 90,000	1,400	16	.0015	$ 133.50	$ 89,000	Victorian	2	1.5	9/10/2009	5/6/2010
186	$ 86,000	1,385	16	.0015	$ 113.25	$ 75,500	Victorian	2	1.5	5/28/2009	4/8/2010
187	$ 112,500	1,710	16	.0015	$ 172.13	$ 114,750	Victorian	2	1.5	10/5/2009	4/19/2010
188	$ 113,900	1,680	17	.0015	$ 158.63	$ 105,750	Ranch	2	1.5	6/9/2009	6/3/2010
189	$ 96,000	1,573	17	.0015	$ 133.88	$ 89,250	Victorian	2	1.5	6/20/2009	6/8/2010
190	$ 125,000	2,180	17	.0015	$ 181.88	$ 121,250	Ranch	3	2	2/2/2010	4/7/2010
191	$ 117,000	1,928	18	.0015	$ 168.38	$ 112,250	Victorian	2	1.5	11/6/2009	4/18/2010
192	$ 159,900	2,440	19	.0015	$ 244.50	$ 163,000	Victorian	3	2	2/26/2010	5/26/2010
193	$ 72,900	1,007	19	.0015	$ 97.13	$ 64,750	Ranch	2	1	1/4/2010	4/24/2010
194	$ 110,000	1,657	20	.0015	$ 150.00	$ 100,000	Ranch	2	1.5	6/16/2009	5/29/2010
195	$ 95,500	1,565	20	.0015	$ 140.25	$ 93,500	Ranch	2	1.5	11/8/2009	6/10/2010
196	$ 93,400	1,543	20	.0015	$ 124.50	$ 83,000	Ranch	2	1.5	10/7/2009	4/16/2010
197	$ 67,000	1,181	21	.0015	$ 92.25	$ 61,500	Ranch	2	1	2/13/2010	5/7/2010
198	$ 89,900	1,464	22	.0015	$ 136.13	$ 90,750	Condo	2	1.5	5/14/2009	4/3/2010
199	$ 71,000	1,083	22	.0015	$ 91.50	$ 61,000	Ranch	2	1	10/15/2009	5/18/2010
200	$ 118,000	1,830	23	.0015	$ 171.38	$ 114,250	Victorian	2	1.5	6/10/2009	4/1/2010
201	$ 87,600	1,156	23	.0015	$ 114.00	$ 76,000	Condo	2	1	7/14/2009	5/4/2010
202	$ 135,000	2,253	23	.0015	$ 174.00	$ 116,000	Ranch	3	2	4/25/2010	4/29/2010
203	$ 73,100	1,299	24	.0015	$ 105.00	$ 70,000	Condo	2	1	12/23/2009	5/30/2010
204	$ 77,300	1,320	24	.0015	$ 113.63	$ 75,750	Ranch	2	1.5	12/20/2009	4/4/2010
205	$ 125,000	2,277	25	.0015	$ 181.88	$ 121,250	Ranch	3	2	8/9/2009	5/7/2010
206	$ 129,900	2,743	25	.0015	$ 175.13	$ 116,750	Victorian	3	2.5	9/13/2009	6/7/2010
207	$ 108,000	2,200	26	.0015	$ 150.38	$ 100,250	Condo	3	2	7/20/2009	4/28/2010
208	$ 169,500	2,931	28	.0015	$ 254.25	$ 169,500	Victorian	3	2.5	7/1/2009	5/8/2010
209	$ 155,300	2,200	28	.0015	$ 211.88	$ 141,250	Victorian	3	2	2/21/2010	6/20/2010
210	$ 102,000	1,713	30	.0015	$ 148.13	$ 98,750	Condo	2	1.5	2/9/2010	5/7/2010
211	$ 72,500	1,140	30	.0015	$ 99.75	$ 66,500	Ranch	2	1	1/5/2010	6/27/2010
212	$ 104,900	1,900	34	.0015	$ 146.25	$ 97,500	Victorian	2	1.5	8/11/2009	4/11/2010
213	$ 72,000	1,050	40	.0015	$ 98.25	$ 65,500	Ranch	2	1	7/23/2009	4/17/2010
214	$ 85,000	1,190	41	.0015	$ 110.63	$ 73,750	Ranch	2	1	10/2/2009	5/20/2010
215	$ 74,900	1,733	43	.0015	$ 99.75	$ 66,500	Victorian	2	1.5	12/1/2009	5/4/2010
216	$ 72,000	1,121	46	.0015	$ 100.13	$ 66,750	Ranch	2	1	9/2/2009	4/20/2010
217	$ 102,000	1,478	53	.0015	$ 137.63	$ 91,750	Ranch	2	1.5	12/21/2009	4/17/2010