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.