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