Hello
Can't seem to get this correct.
I have two columns A ( staffid) B (old staff id)
and in another column C I have a mix of staff ID's
I want to search this mix and look in Column A and Column B if is exists return "yes" and if not then "no"
Its over the two columns part I seem to be struggling with.
Thanks
Ross
Bookmarks