If function with nested MONTH function

chelsm

New Member
Joined
Mar 13, 2018
Messages
4
Hello,

I'm trying to get cell N5 to return the monthly value from row 5 depending on the current month.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
=IF(MONTH(K1),K5,IF(MONTH(B1),B5,IF(MONTH(C1),C5,IF(MONTH(D1),D5,IF(MONTH(E1),E5,IF(MONTH(F1),F5,IF(MONTH(G1),G5,IF(MONTH(H1),H5,IF(MONTH(I1),I5,IF(MONTH(J1),J5,IF(MONTH(L1),L5,IF(MONTH(M1),M5,0))))))))))))

[TABLE="width: 794"]
<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="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523; mso-outline-level: 1;"> <col width="118" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4315;"> <tbody>[TR]
[TD="class: xl73, width: 93, bgcolor: black"] [/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]4[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]5[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]6[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]7[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]8[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]9[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]10[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]11[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]12[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]1[/TD]
[TD="class: xl78, width: 70, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]2[/TD]
[TD="class: xl78, width: 69, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] , align: right"]3[/TD]
[TD="class: xl73, 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: xl77, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=366092]#366092[/URL] "]CY MONTH[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Lease[/TD]
[TD="class: xl67, bgcolor: transparent"] $ 10,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 11,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 12,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 13,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 14,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 15,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 16,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 17,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 18,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 19,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 20,000 [/TD]
[TD="class: xl67, bgcolor: transparent"] $ 21,000 [/TD]
[TD="class: xl74, bgcolor: transparent"] $ 19,000 [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]Hydro[/TD]
[TD="class: xl68, bgcolor: transparent"] $ 1 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 2 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 3 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 4 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 5 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 6 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 7 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 8 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 9 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 10 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 11 [/TD]
[TD="class: xl68, bgcolor: transparent"] $ 12 [/TD]
[TD="class: xl75, bgcolor: transparent"] $ 10 [/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #8DB4E2"]HOME[/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 10,001 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 11,002 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 12,003 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 13,004 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 14,005 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 15,006 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 16,007 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 17,008 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 18,009 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 19,010 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 20,011 [/TD]
[TD="class: xl72, bgcolor: #8DB4E2"] $ 21,012 [/TD]
[TD="class: xl76, bgcolor: #C5D9F1"] $ 19,010 [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
chelsm, Good evening.

To search values depending of the current month you can try:

N3 -->
Code:
=INDEX($B$3:$M$5,ROW(A[B][COLOR=#ff0000]1[/COLOR][/B]),MATCH(MONTH(TODAY()),$B$1:$M$1,0))
N4 -->
Code:
=INDEX($B$3:$M$5,ROW(A[B][COLOR=#ff0000]2[/COLOR][/B]),MATCH(MONTH(TODAY()),$B$1:$M$1,0))
N5 -->
Code:
=INDEX($B$3:$M$5,ROW(A[B][COLOR=#ff0000]3[/COLOR][/B]),MATCH(MONTH(TODAY()),$B$1:$M$1,0))

https://www.sendspace.com/file/dwyr4c

Is that what you want?

I hope it helps.
 
Upvote 0
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]
 
Upvote 0

Forum statistics

Threads
1,223,981
Messages
6,175,768
Members
452,668
Latest member
mrider123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top