You should be able to adjust the ranges as follows:

=INDEX(trends!F6:06,MATCH(MONTH(TODAY()),MONTH(tre nds!F4:O4),0))

Again, it is an array formula, so you will need to hit Control+Shift+Enter
when you key it in, not just the Enter key. If you do it right, Excel will
put braces { } around the formula.



"jay d" wrote:


hi

i want to have this

Code:
--------------------
=IF(MONTH(TODAY())=(MONTH(Trends!$f$4)),Trends!f6, IF(MONTH(TODAY())=(MONTH(Trends!$g$4)),Trends!g6, IF(MONTH(TODAY())=(MONTH(Trends!$H$4)),Trends!H6, IF(MONTH(TODAY())=(MONTH(Trends!$i$4)),Trends!i6, IF(MONTH(TODAY())=(MONTH(Trends!$j$4)),Trends!j6, IF(MONTH(TODAY())=(MONTH(Trends!$k$4)),Trends!k6, IF(MONTH(TODAY())=(MONTH(Trends!$l$4)),Trends!l6,I F(MONTH(TODAY())=(MONTH(Trends!$m$4)),Trends!m6, IF(MONTH(TODAY())=(MONTH(Trends!$n$4)),Trends!n6, IF(MONTH(TODAY())=(MONTH(Trends!$o$4)),Trends!o6,)
--------------------


but its more than 7 functions...

thanks


--
jay d
------------------------------------------------------------------------
jay d's Profile: http://www.excelforum.com/member.php...o&userid=34487
View this thread: http://www.excelforum.com/showthread...hreadid=553261