Hello All,



I want the following functionality in excel.
If in the entire column B if any of the following string is found get the corresponding value of another cell in Column A.

String to search:
OK
NOT OK
BLOCKING
NOT TESTED

See the example at the following link:
http://www.flickr.com/photos/7714646...in/photostream
In this example the result found are displayed in Column E. So the formula need to be put in column E. Notice that Each row in column E should display the result from column A as soon as the string is found in column B. What formula do I need to put in column E & where? Please suggest.

Thanks,
Zee

Hi and welcome
Why post a link to a picture when you can upload a sheet?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post