How can I perform the following formula from one worksheet on another
worksheet.

For example, I use this formula to derive an answer on a worksheet
named Data, I want to use the same formula to get the same answer only
do it from a different worksheet named Input.

=IF(Date=0,"",OFFSET($E$5:$E$106,,MATCH(Date,$F$3: $CT$3,0)))

Any ideas?

Thanks.

EP


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