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.

	A	B	C	D
		Over_4_Years	Over_6_Years	Over_8_Years
1	Salary_3	70,000	72,000	74,000
2	Salary_2	60,000	62,000	64,000
3	Salary_1	50,000	52,000	54,000

<tbody>
</tbody>

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

SAMPLE

Salary	(using drop down selection) Salary_2
Years of Service	(using drop down selection) Over_6_Years
Total Base Salary	(displayed result) $62,000

<tbody>
</tbody>

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