Hello, Say I have a number of data in columns I-J. I is an index, J is a text. What I want is to search all lines that have "A" in column I, and have the adjacent text from column J to appear in column L, while skipping the lines that have "B". Anyone knows a formula for this that I can enter in column L ? I wouldn't mind the intermediate column K.