Having trouble with INDIRECT formula to find intersecting rows and columns

GunnyRet

New Member
Joined
Jul 18, 2016
Messages
1
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.

ABCD
Over_4_YearsOver_6_YearsOver_8_Years
1Salary_370,00072,00074,000
2Salary_260,00062,00064,000
3Salary_150,00052,00054,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
Joined
Oct 12, 2006
Messages
44,061
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:
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top