Hi EP,

Try:
if either Date should < 0 or H9 should = "Day":
=IF(OR(Date=0,H9<"Day"),"",OFFSET(Data!$E$5,ROW(A 1)+100,MATCH(G8,Data!$F$3:
$CT$3,0)))
or, if both Date should < 0 and H9 should = "Day":
=IF(AND(Date=0,H9<"Day"),"",OFFSET(Data!$E$5,ROW( A1)+100,MATCH(G8,Data!$F$3
:$CT$3,0)))

Cheers

"edwardpestian"
wrote in message
news:edwardpestian.27dd5a_1146891001.7016@excelfor um-nospam.com...

I would like to know if I can add another IF statement to the following
formula. For example IF cell H9 = "Day" then perform the function.

Thanks.

EP

=IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G 8,Data!$F$3:$CT$3,0)))


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=539484