indirect error

  1. StephenArg

    INDIRECT Formula shows #VALUE! error when opening the file

    I have an Excel workbook with no external references and no VBA. There are only 4 worksheets in the file and on one of those worksheets, I use the INDIRECT formula to automate getting a value from a cell in a different worksheet in the same workbook. The formula is looking for a value from...
    • StephenArg
    • Thread
    • #value! error indirect error indirect formula mac excel value
    • Replies: 2
    • Forum: Excel Questions
  2. X

    INDIRECT doesnt work properly

    I dont know if i just dont understand things, but as for my understandings this formular just doesnt work for me in this scenario. I want to refer to an already existing name with INDIRECT(). I want this range to end up as my dropdownlist. The name i want to refer to is called "DropDown1"...
    • Xalova
    • Thread
    • error help help - names indirect error indirect function name
    • Replies: 17
    • Forum: Excel Questions
  3. S

    SUMIF/SUMIFS Indirect

    Hello, I've attached (I think) an example of what my work looks like. Each tab represents a different location, each color a different team. I'm trying to use the sumif(indirect) formulas to find the totals on the overview tab. Teams review/change qty often and the number of sn may...
  4. S

    Networkdays - cell determines holiday list/range to use

    Please help I want use Networkdays to determine how many hours per workday a team member will need to spend on each task. The problem I am having is I need to account for the team members days off also. I have created a named list for each team member (using their name) that has all of their...

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
Back
Top