Forum Discussion
Need Help - Searching and Comparing a String
I am having a little bit of an issue. I need to compare a string in one column to another, then provide the string in another column. The problem is I have to search the entire column and will not be...
Hi Anonymous,
First I'd like to thank you for your help. When I use your formula I receive "A circular dependency was detected". I think this is because I did not state in my example above that value can be had more than once. Example below:
| Column A | Column B | Column C | Column D | Column E |
| ABC | XYZ | Business Unit 1 | ||
| ABC | XYZ | Business Unit 2 | ||
| DDC | TTV | Business Unit 3 | ||
| DDC | TTV | Business Unit 4 | ||
| ABC | XYZ | Business Unit 5 | ||
| ABC | XYZ | Business Unit 6 | ||
| DDC | DDC | Business Unit 7 |