Problem:

- This is a spread sheet that records numbers chosen for a lottery bonus ball. The spread sheet is a very simplified version of the one I am working with however I have extracted the problem I am encountering.

- The master spread sheet will allow me to return many different coding values to build a webpage based on the data within. I am however; stuck on a solution to this issue. I would prefer to use a formula solution as VBA is not good for Mac Excel.

- Column C checks the chosen number in Column B against a range of numbers recorded as drawn on the Draws sheet. If it finds them it marks Column 'C' with a Y.

Q: My conundrum is, I would like the Y to be marked only if the number matching was drawn after the registration date in the draws column.

You can download my spread sheet here forum.ozgrid.com/index.php?attachment/69161/

Any help appreciated.