Never mind I figured it out. What if I have a second home? If I use =INDEX($B$6:$M$8,ROW(A4),MATCH(MONTH(TODAY())-1,$B$1:$M$1,0)) it doesn't return a value. I tried to use a number of different rows such as A1, A5 or A6
[TABLE="width: 774"]
<colgroup><col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-level: 1;"> <col width="43" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572; mso-outline-level: 1;"> <col width="118" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4315;"> <tbody>[TR]
[TD="class: xl76, width: 93, bgcolor: black"] [/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]4[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]5[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]6[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]7[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]8[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]9[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]10[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]11[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]12[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]1[/COLOR][/TD]
[TD="class: xl77, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]2[/COLOR][/TD]
[TD="class: xl77, width: 43, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] ]3[/COLOR][/TD]
[TD="class: xl76, width: 118, bgcolor: black"]EXPAND FOR BREAKDOWN[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #0F243E"]LOC[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]APR[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]MAY[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]JUN[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]JUL[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]AUG[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]SEP[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]OCT[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]NOV[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]DEC[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]JAN[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]FEB[/TD]
[TD="class: xl66, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]MAR[/TD]
[TD="class: xl81, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]CY MONTH[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]Lease[/TD]
[TD="class: xl67, bgcolor: transparent"] $ 19,598 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 19,815 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 21,080 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 23,573 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,182 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,145 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 20,011 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 20,170 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 19,209 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 19,537 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 18,430 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] $ 18,430 [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Hydro[/TD]
[TD="class: xl68, bgcolor: transparent"] $ 2,477 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 1,969 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,366 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 1,697 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 4,837 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,097 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 4,012 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 2,610 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 2,639 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,690 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 16,888 [/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl82, bgcolor: transparent"] $ 16,888 [/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: #8DB4E2"]Home 1[/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 22,075 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 21,784 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 24,446 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 25,270 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 27,019 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 25,242 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 24,023 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 22,780 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 21,848 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 23,227 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ 35,318 [/TD]
[TD="class: xl73, bgcolor: #8DB4E2"] $ - [/TD]
[TD="class: xl75, bgcolor: #8DB4E2"] $ 35,318 [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]Lease[/TD]
[TD="class: xl67, bgcolor: transparent"] $ 21,865 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 23,025 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 21,595 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,089 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,438 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,214 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,711 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,266 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 22,042 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 23,756 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 20,182 [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent, align: center"]#REF![/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Hydro[/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,781 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,849 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,662 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 1,727 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,237 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 1,758 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3,070 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 2,868 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 4,949 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 4,359 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 2,354 [/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: transparent"] $ - [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: #C5D9F1"]Home2[/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 25,646 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 26,874 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 25,257 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 23,816 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 25,675 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 23,972 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 25,781 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 25,134 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 26,991 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 28,115 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ 22,536 [/TD]
[TD="class: xl74, bgcolor: #C5D9F1"] $ - [/TD]
[TD="class: xl80, bgcolor: #C5D9F1"] $ - [/TD]
[/TR]
</tbody>[/TABLE]