software

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,quot;quot;,OFFSET(Data!$E$5,ROW(A1) 100,MATCH(G 8,Data!$F$3:$CT$3,0)))

Any suggestions?

Regards,

EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539176One way, if I understand you correctly:

=IF(Date=0, quot;quot;, OFFSET(Data!$E$5, ROW(A1) 100, MATCH(G8,
Data!$F$3:$CT$3, 0) 1))
In article
gt;,
edwardpestian
gt; wrote:

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


It worked as expeted.

Thanks.

Regards,
EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539176
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, quot;quot;, OFFSET(Data!$E$5, ROW(A1) 100, MATCH(G8,
Data!$F$3:$CT$3, 0) 1))

Thanks again.

EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=539176