Has anyone come across an issue where an & in the lookup expression gives incorrect results.
I am trying to lookup a department which is "Project Operations & Management" and it gives incorrect results only for this department. Is it because of the "&"
How can I avoid this situation?