7 function rule cont.

ok everyone asked for more details, so here they are...good luck and thanks
for helping. Specifically i have a two page workbook, on the first page is a
registration table for tournaments including name, address, phone number,
etc...simple stuff...but here is the tricky part...i have a cell with a pull
down option (validation) with a list of different tournaments we run (8
different names), and another cell with a count of people in the tournament
(counted from the list of names), on the second page i have all 8 tournaments
described in colums, (name, day, start time, and payouts for winners), now
that is where the problem starts. all eight tournaments pay different %s for
1st through 10th place and it also depends on if we have 50 or more people in
the tournament...so this is 16 different % payout tables listed on second
page. I have only one payout table on 1st page and want the table to switch
to right % based on which tournament is selected from pull down box and also
how many people are in it (more or less than 50), so i was doing fine with
nested if's and was just gonna do that for all 16 combinations till i ran
into the 7 function rule. People have suggested Vlookups and Hlookups but i
dont know how this would help since i have to ask it if it was this
tournament with this many people the payout table would look like this....I
know this is alot to comprehend...appreciate any ideas...thanks.

I'm still not sure what you want but you can have ifs within lookup tables
example only
=vlookup(a2,if(a350,table2,table1),if(a4=3,3,2),f alse)
--
Don Guillett
SalesAid Software

"HELPME" wrote in message
...
ok everyone asked for more details, so here they are...good luck and
thanks
for helping. Specifically i have a two page workbook, on the first page
is a
registration table for tournaments including name, address, phone number,
etc...simple stuff...but here is the tricky part...i have a cell with a
pull
down option (validation) with a list of different tournaments we run (8
different names), and another cell with a count of people in the
tournament
(counted from the list of names), on the second page i have all 8
tournaments
described in colums, (name, day, start time, and payouts for winners), now
that is where the problem starts. all eight tournaments pay different %s
for
1st through 10th place and it also depends on if we have 50 or more people
in
the tournament...so this is 16 different % payout tables listed on second
page. I have only one payout table on 1st page and want the table to
switch
to right % based on which tournament is selected from pull down box and
also
how many people are in it (more or less than 50), so i was doing fine with
nested if's and was just gonna do that for all 16 combinations till i ran
into the 7 function rule. People have suggested Vlookups and Hlookups but
i
dont know how this would help since i have to ask it if it was this
tournament with this many people the payout table would look like
this....I
know this is alot to comprehend...appreciate any ideas...thanks.