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.