Im wrking on a sheet to use for lotto. I have a separate columns of the numbers Ive chosen and want to compare them to whats been drawn. I can use the HLookup formula but it will only 1 cell. I need it to lookup all the cells in a row to see if that number was picked.

Any suggestions are appreciated