> (e-mail address removed) wrote:
>
> > Version: 2008
> > Operating System: Mac OS X 10.5 (Leopard)
> > Processor: Intel
> >
> > I'm trying to make a workbook in Excel that has 3 pages to it. The main page
> > will have varying data such as age, gender, and 3 individual scores. The
> > second page is the scoring system for males based on repetitions and age, the
> > third page is the female scoring system. When I put in the age and gender of
> > someone on the main page, I want it to take me to the page that is for them
> > (male or female) and then the age group within that page. Then based on the
> > repetitions entered on the main page, it will give a score in another cell.
> > Then I want to show a pass or fail based on 60 points or higher for all three
> > events. Any help would really be great.
>
> Your problem statement is a little vague.
>
> There's nothing that can "take" you anywhere, but perhaps something like
> this:
>
> Three worksheets: Main, Male, Female
>
> On the Male Page:
>
> A B C D ...
> 1 Age 1 2 3
> 2 18
> 3 19
>
> Select the table, and name it "Male_Table"
>
> Similarly for the Female page.
>
> On the Main page:
>
> A B C D E
> 1 Name Age Gender Reps Score
> 2 Joe 19 M 2
> 3 Pam 22 F 4
>
> Then in E2:
>
> =IF(C2="M", VLOOKUP(B2, Male_Table, MATCH(D2,
> OFFSET(Male_Table,,,1,), TRUE), TRUE), VLOOKUP(B2, Female_Table,
> MATCH(D2, OFFSET(Female_Table,,,1,), TRUE), TRUE))
>
> Copy down as far as necessary...
> [/QUOTE]
If it would help, I can send you a copy of the workbook I'm working on. This would maybe explain a little better than I was able to. The problem I have is that multiple pieces of data on the first page need to link to the 2nd or 3rd page which will supply more data for the first page. It's pretty hard to explain without you being able to look at it.
