AnsweredAssumed Answered

pulling data from a large table

Question asked by doct on Oct 23, 2013
Latest reply on Oct 23, 2013 by taylorsharpe

Need to pull a specific value from a 10 x 20 reference table based on the axis values which varies by record. I could create a field for each of the 200 values and then use a very long if...then equation to pull the correct data, but think there might be an easier way, I just don't know what it is.


Table is age adjusted hearing loss based on frequency, age and gender ( Table has 20 years with 5 frequencies adjustments per gender (10 across and 20 down).


Could anyone point me in the right direction? Thanks.