Lookup Function

S

Steve

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
 
R

Roger Govier

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))
 
B

Bob Phillips

Might want some error handling

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top