Try this in any starting cell in the sheet: Input
=IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)-1,MATCH(Date,Data!$F$3:$CT$3,0)))
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"edwardpestian" wrote:

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