OK so i am new to the File Maker format. I am a Drill Sergeant and I have privates take a PT Test and what I want to do is create fields that compare age and gender and compare them with number of repetitions of push ups. I am trying to figure out how to take to pieces of data as though it was a spread sheet and find the value of where the two meet. I may just be using the wrong logic thought process.
MALES AGE FEMALES AGE
If the record for PVT JOE SNUFF reads
AGE: 23 GENDER: MALE and REPS: 57 so I want the Points Field to return a value of 75.
and if its
AGE: 34 GENDER: FEMALE and REPS: 58 so I want the Points Field to return a value of 96.
IF this was EXCEL I would use Index(REPS, A1:A100, Match(AGE, B1:I1,0) or something to that effect.
Can anyone help me?