return a value from 2 dimensional table

**bertique** · 03-26-2012, 12:17 AM

btw, can i return a value automatically from a multidimensional table? how can i do it?

Example:
Rank Salary vs. Increment
Below 5,000 5,000 - 9,999 10,000 - 14,999 15,000 - 19,999 20,000 and above
3+ 5.00% 4.50% 4.00% 3.00% 2.00%
3 4.50% 4.00% 3.50% 2.50% 1.50%
2 2.25% 2.00% 1.75% 1.25% 0.00%

Rank Salary Increment
Employee A 3+ 7980 ??

**DGagnon** · 03-26-2012, 12:30 AM

you could use this formula but you need to adjust your headers across the columns as per the attached example

=INDEX(D6:H8,MATCH(D12,C6:C8,0),MATCH(E12,D5:H5,1))

you could insert another row just above row 5 to include some decriptions, or even bellow it. but you need to have a number range to do a lookup.

**protonLeah** · 03-26-2012, 12:40 AM

Try:
=INDEX(D6:H8,MATCH(D12,C6:C8,0),MATCH(E12,D5:H5,1))

**bertique** · 03-26-2012, 01:14 AM

thanks, it works.

what if, there is another complication i.e. the increment is decided based on the grade? index and match works, but how to check using if statement.

thanks