Offset formula on different worksheet
 

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

Offset formula on different worksheet
 

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

Offset formula on different worksheet
 

Now I'd like to take it one step further and have the forumula match
based on two different cell criteria: G8 and H8. Can I do this?

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

Thanks again.

EP


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

Offset formula on different worksheet
 

Glad to see you got it sorted out in your later post !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---