|Posted: December 31, 2005, 7:10 pm - IP Logged|
type hlookup or vlookup in excel help, there are examples there
here is an example of a regular lookup...
from my vtrac102 sheet:
C2 = lookup value... is the number drawn in the first position
$X$3:$X$12 = lookup vector... contain the digits 0 thru 9 (X3=0, X12=9)
$Y$3:$Y$12 = result vector... contain the corresponding vtrac value for each digit (0 and 5 = 1, etc)
I anchor the X and Y cells so when I autofill down, the reference stays valid, and I left C2 relative, that way I could autofill down and over in one step and reference the cells from the draw history
the form (from excel help file) is
=LOOKUP(lookup_value, lookup_vector, [result_vector])
Playing more than one ticket per game is betting against yourself.