number lookup
 

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

number lookup
 

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