# Having trouble with INDIRECT formula to find intersecting rows and columns

#### GunnyRet

##### New Member
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.

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Jonmo1

##### MrExcel MVP
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

Last edited:

Replies
3
Views
839
Replies
6
Views
613

1,186,662
Messages
5,959,060
Members
438,396
Latest member
Louise Rodway

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back