I have a column B5:B26 and I would like to search it for R1, R2, and R3. If one of them is present in the column, I want that value in the cell. i.e. "R1" or "R2" or "R3". If there is no R1,R2, R3, then I would like nothing in the cell. The column will only ever have one of the three values or nothing. I have spent hours on this....