I am at a lost right now on how to accomplish this task. The endstate is I want one text field to calculate using criteria from a table. I know this is confusing. Here is the layout. I want to search the table by using the age, and then to search another criteria for how many repititions was performed and give a score by male or female. So something like this (I know this isn't code): If Age >=22 or <=26, find age header, if # of reps entered, if Male use this score entered in textfield 1. That is a rough estimate of what it looks like. I can submit to you the document that I am trying to do if that would help.
