Lookup Function
 

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 "Yes". When the first "Yes" is

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

column but six rows above from where the "Yes" value was found.



Any help or suggestions on the above would be most appreciated.



Thanks,



Steve

Lookup Function
 

Hi Steve

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

--
Regards

Roger Govier


"Steve" wrote in message
news:bYGAf.420116$ki.320725@pd7tw2no...
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 "Yes". When the first "Yes" is

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

column but six rows above from where the "Yes" value was found.



Any help or suggestions on the above would be most appreciated.



Thanks,



Steve

Lookup Function
 

Might want some error handling

=IF(ISNUMBER(MATCH("yes",A9:N9,0)),INDEX(A3:N3,MAT CH("yes",A9:N9,0)),"Not
found")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Roger Govier" wrote in message
...
Hi Steve

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

--
Regards

Roger Govier


"Steve" wrote in message
news:bYGAf.420116$ki.320725@pd7tw2no...
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 "Yes". When the first "Yes" is

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

column but six rows above from where the "Yes" value was found.



Any help or suggestions on the above would be most appreciated.



Thanks,



Steve