Setting Up Two-Dimensional Tables

A two-dimensional table has two lookup bases. You can picture it as a grid. For example, you could use the following grid to look up information based on both age and service:

Age	5 Years Service	10 Years Service	15 Years Service
55	A	B	C
60	D	E	F
65	G	H	I

You create two-dimensional tables with two columns of lookup values: lookup one and lookup two. Set up the table with all rows for the first lookup one value, all rows with the next lookup one value, and so on.

For example, a two-dimensional lookup table is shown below. Lookup one is age, and lookup two is service. Following the example shown above, the lookup one values are set up as follows: all the service values for age 55, all values for age 60, then all values for age 65. The final table would look like this:

Seq Number	Age	Service	Result
5	55	5	A
10	55	10	B
15	55	15	C
20	60	5	D
25	60	10	E
30	60	15	F
35	65	5	G
40	65	10	H
45	65	15	I