Hi,

Suppose you set up the following lookup table:
0 No Luck
3 £10.00
4 About £50.00
5 About £500.00
5.5 Big Money
6 Jackpot

Then you could use a simple formula like:

=VLOOKUP(W9/2+S9,A1:B6,2)

where the table is in the range A1:B6.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))