software

Hi,
I would really appreciate some help with the following:
I need to build a formula that searches a row in an excel table

for the first instance of the word quot;Yesquot;. When the first quot;Yesquot; is

found the formula needs to retrieve a date value from the same

column but six rows above from where the quot;Yesquot; value was found.
Any help or suggestions on the above would be most appreciated.
Thanks,
Steve
Hi Steve

Try
=INDEX(A3:N3,MATCH(quot;yesquot;,A9:N9,0)) change ranges to suit
or if you really do mean the whole row then
=INDEX(3:3,MATCH(quot;yesquot;,9:9,0))

--
Regards

Roger Govierquot;Stevequot; gt; wrote in message
news:bYGAf.420116$ki.320725@pd7tw2no...
gt; Hi,
gt;
gt;
gt;
gt; I would really appreciate some help with the following:
gt;
gt;
gt;
gt; I need to build a formula that searches a row in an excel table
gt;
gt; for the first instance of the word quot;Yesquot;. When the first quot;Yesquot; is
gt;
gt; found the formula needs to retrieve a date value from the same
gt;
gt; column but six rows above from where the quot;Yesquot; value was found.
gt;
gt;
gt;
gt; Any help or suggestions on the above would be most appreciated.
gt;
gt;
gt;
gt; Thanks,
gt;
gt;
gt;
gt; Steve
gt;
gt;
Might want some error handling

=IF(ISNUMBER(MATCH(quot;yesquot;,A9:N9,0)),INDEX(A3:N3,MAT CH(quot;yesquot;,A9:N9,0)),quot;Not
foundquot;)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Roger Govierquot; gt; wrote in message
...
gt; Hi Steve
gt;
gt; Try
gt; =INDEX(A3:N3,MATCH(quot;yesquot;,A9:N9,0)) change ranges to suit
gt; or if you really do mean the whole row then
gt; =INDEX(3:3,MATCH(quot;yesquot;,9:9,0))
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Stevequot; gt; wrote in message
gt; news:bYGAf.420116$ki.320725@pd7tw2no...
gt; gt; Hi,
gt; gt;
gt; gt;
gt; gt;
gt; gt; I would really appreciate some help with the following:
gt; gt;
gt; gt;
gt; gt;
gt; gt; I need to build a formula that searches a row in an excel table
gt; gt;
gt; gt; for the first instance of the word quot;Yesquot;. When the first quot;Yesquot; is
gt; gt;
gt; gt; found the formula needs to retrieve a date value from the same
gt; gt;
gt; gt; column but six rows above from where the quot;Yesquot; value was found.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Any help or suggestions on the above would be most appreciated.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt;
gt; gt;
gt; gt; Steve
gt; gt;
gt; gt;
gt;
gt;