number lookup

[wcthrill]

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

[JR]

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.

"wcthrill" wrote:

>
> 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
>
>
> --
> wcthrill
> ------------------------------------------------------------------------
> wcthrill's Profile: http://www.excelforum.com/member.php...o&userid=30165
> View this thread: http://www.excelforum.com/showthread...hreadid=529741
>
>