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 (https://www.osha.gov/pls/oshaweb/owadisp.show_document?p_id=9741&p_table=STANDARDS. Table has 20 years with 5 frequencies adjustments per gender (10 across and 20 down).

 

Could anyone point me in the right direction? Thanks.

Outcomes