Hi,
I am trying to use an 'IF' statement to look up a date and return a Yes/No if the date exists.
The 'IF' statement is looking at a cell whose data is being found by a 'VLookUp'
See attached file.
The problem I am having is the 'IF' statement is not picking up the month even though it exists in the cell. The date is formatted - mmm.
I think it may be a formatting issue but not sure how to resolve.
Terry
Bookmarks