Offset to different worksheet problem

[edwardpestian]

I have the formula below, which takes the date from a cell(G8) and finds the corresponding data in another worksheet(Data!). This formula is working. But for some reason I can't get a second formula to look up the data one cell to the right.

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

Any suggestions?

Regards,

EP

[JE McGimpsey]

One way, if I understand you correctly:

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



In article
<[email protected]>,
edwardpestian
<[email protected]> wrote:

> I have the formula below, which takes the date from a cell(G8) and finds
> the corresponding data in another worksheet(Data!). This formula is
> working. But for some reason I can't get a second formula to look up
> the data one cell to the right.
>
> =IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G8,Data!$F$3:$CT$3,0)))
>
> Any suggestions?
>
> Regards,
>
> EP

[edwardpestian]

It worked as expeted.

Thanks.

Regards,
EP

[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