Thanks. And lets say I wanted to have every time "CAD" was in column A, for it to show a value of something in the adjacent column A2. How could I do that?