Offset formula on different worksheet

[edwardpestian]

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

 

[Guest]

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

 

[edwardpestian]

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

 

[Guest]

Glad to see you got it sorted out in your later post !

---