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:
See the example at the following link:
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