number lookup

[wcthrill]

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

Any suggestions are appreciate

 

[Guest]

Try using a vlookup for each one of your numbers, on each column of drawn
numbers. So, if 5 numbers are drawn, you would have 5 vlookups under each of
your numbers.