Hi
I have 500 rows of data, in column B is a Task and column C has a location or is empty
The information held in column C is located in column B.
Ideally I would like to check each cell in column C and compare to all cells in Column B, if their is a match I would like Column D to hold a value...