Hello All,

Can anyone help me to perform the following action in excel 2007

Search a string in column A, which contains set of text data, and than display that string to next column B or C or D, if found,

With vlookup, match, etc I am able to find the string value but unable to display them as described above.

TIA
Nick