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