Hi,

MaximS: Actually what I want, when ever there is an occurrence of a 2 in column B, I want the corresponding value from A returned. But all the Values from A should be concatendated in one cell.