Fing value in column and associate result to it

[Guest]

Excel 2003:

I need to search a value in worksheet (2) that exists in worksheet (1), confirm if it status, in the same row but another column, is "ok" or "not ok" and associate a result for the search ("yes" if "ok" or "no" if "not ok"). But in worksheet (2) there are more than one result for each search.

Example:
worksheet 1: | worksheet 2:
column A | column A column B
HOME | HOME---------------ok
CAT | HOME--------------not ok
DOG | HOME--------------not ok
FATHER | DOG-----------------ok
MOTHER | DOG-----------------not ok
SON | CAT-----------------not ok


If one of the values on status (column B, worksheet 2) is "ok" for the same name associated (column A), the result is "yes", independently if the other status is "not ok"

Thanks a lot
Eduardo

 

[Andy B]

See reply in misc - and please don't multipost.

--
Andy.

Excel 2003:

I need to search a value in worksheet (2) that exists in worksheet (1),

confirm if it status, in the same row but another column, is "ok" or "not
ok" and associate a result for the search ("yes" if "ok" or "no" if "not
ok"). But in worksheet (2) there are more than one result for each search.

Example:
worksheet 1: | worksheet 2:
column A | column A column B
HOME | HOME---------------ok
CAT | HOME--------------not ok
DOG | HOME--------------not ok
FATHER | DOG-----------------ok
MOTHER | DOG-----------------not ok
SON | CAT-----------------not ok


If one of the values on status (column B, worksheet 2) is "ok" for the

same name associated (column A), the result is "yes", independently if the
other status is "not ok"