indirect formula

I have a cell with the formula =IFERROR(@INDIRECT("3!$M$6"),0) which works fine. I would like to replace "3!$M$6" with an IF statement IF('3'!$M$6=5,$M$3,'3'!$M$6) Everything I've tried has not worked. The formula refers to tabs that are not yet there, but can be added if necessary. If the...

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...

Hello, I am trying to use COUNTIFS and INDIRECT but my formula is not working. I have different sheets, and each sheet represents a store location. In each sheet, there is a Sales Person name and the sales amount generated for each store item (e.g., shoes, tops, dresses). In my summary sheet...

Hello Everyone, I have two sheets with follow data: Sheet 1 SR. No Data 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H Sheet 2 SL. No Data 1 100 2 200 3 300 4 400 5 500 6 600 7 700 8 800 I am looking for a formula/way to copy data from above sheets to a third...

I'm looking for assistance on an Offset/Indirect formula I am using MIN Formula is =OFFSET(INDIRECT(B8),0,1,1,1) MAX Formula is=OFFSET(INDIRECT(B8),0,2,1,1) Good news is that those formulas pull from the correct Named Cell Areas Bad news is that the Offset hard wires the Min Max Cells as the...

Hello, I am trying to find a macro or a formula that will delete out interdependent dropdowns. I am a macro noob so thanks in advance for your patience. Right now, I have a sheet that is set up using the indirect formula via data validation to allow the user to select various dropdowns. For...

Hi all, Was recommended to visit by a colleague whom people here had previously helped somewhat massively, hoping you won't mind me asking for your assistance as well! I'm almost certain that this is a really stupid, obvious thing I'm doing wrong, but despite a lot of Googling, different...

I have a workbook with 1 tab per calendar day for basic Hotel/guest management system. Each tab has a table to manage daily check in / check out info & payments made by customers. I want to be able to have a formula on each tab that recognizes the check in & check out date and: 1) Updates all...

Hi, I am trying to replace a formula in a workbook to use the INDIRECT function to link to other worksheets in the same workbook This is the formula I am wanting to replace: =INDEX('Andrew'!$A$7:$R$18,$B$11,18) This is what I have been trying to replace it with but it returns an error saying...

I have different tabs for each student, with the same table on each with different data. I have a main dashboard tab that I want separate data from each student from different dates. 1. What is wrong with my "Jan Hours function" and can I use indirect? 2. How can I use the column name [Hours] in...

I have a worksheet that users input employee names and date of birth for various calculations. A few users are deleting rows that are causing #REF errors with the calculations and I am looking for a solution around it. Indirect or Offset are options I am considering to solve the issue. Here...

Hello I have a basic understanding of spreadsheets and formulas but am out of my depth and need your help and advice! I have a workbook that has multiple spreadsheets. The first is a summary sheet, the others are for each year. I would like the summary sheet to show the number of times a...