Hi

Very simple one, its to do with lottery drawn numbers. B1:B6 are the drawn numbers and A10:A59 are heading number 1 to 49. When draw is out, the relevant number will appear under its relevant heading number.

Thx