Having trouble with INDIRECT formula to find intersecting rows and columns

[GunnyRet]

Hello,

I am new to the forum, and hope someone can help.

I need to create a "dashboard" for my end users that will automatically return a result like my sample below.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Over_4_Years[/TD]
[TD]Over_6_Years[/TD]
[TD]Over_8_Years[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Salary_3[/TD]
[TD]70,000[/TD]
[TD]72,000[/TD]
[TD]74,000[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Salary_2[/TD]
[TD]60,000[/TD]
[TD]62,000[/TD]
[TD]64,000[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Salary_1[/TD]
[TD]50,000[/TD]
[TD]52,000[/TD]
[TD]54,000[/TD]
[/TR]
</tbody>[/TABLE]

I have been successful naming the Salary and Years of Service ranges by "creating from selection". As you may know, this creates dropdowns.

SAMPLE

[TABLE="width: 500"]
<tbody>[TR]
[TD]Salary[/TD]
[TD](using drop down selection) Salary_2[/TD]
[/TR]
[TR]
[TD]Years of Service[/TD]
[TD](using drop down selection) Over_6_Years[/TD]
[/TR]
[TR]
[TD]Total Base Salary[/TD]
[TD](displayed result) $62,000[/TD]
[/TR]
</tbody>[/TABLE]


First problem is getting the =INDIRECT (A2) INDIRECT (C2) function to work. I keeping getting #REF! errors here.
Second problem is I don't know that dashboards can be created in 2016 any longer.
Thirdly, I need to make this tool work behind the scenes so that my users can simply input a Salary Row, then a Years of Service Column based on an individual to show what their "Total Base Salary" should be.

 

[Jonmo1]

First problem is getting the =INDIRECT (A2) INDIRECT (C2) function to work. I keeping getting #REF! errors here.

Wouldn't that need to be C1
Because 'Over_6_Years" is in C1, not C2..

This works for me
=(INDIRECT(A2) INDIRECT(C1))
But it displays 72000 because A2 = Salaray_3

If you want 62000, then it needs to be A3 and C1