indirect function

I am trying to find an alternative to INDIRECT. I started modifying a spreadsheet using INDIRECT, but I am worried about the future implications considering INDIRECT is a volatile function. The spreadsheet is not huge, but it is on going. There is a new tab for every month, going back to 2002. I...

Hello all I am having difficulty creating an autofill formula. The first tab of my file is called "By Room" and I would like to link exactly every 9th cell down the sheet (starting with B7 and going forward, B16, B25, B34, B43 etc.) to the second tab, called "Ceilings" into every cell without...

Hi guys, I'm trying to use the INDIRECT function to auto-update a formula based on a pull-down menu from cell B9 for a given table name. This table is a list of TAB-NAMES . key:: B9 [Pull down menu] = staff name A table of "names" on a separate sheet 'Main' from Column A4 - A99 C3 = Year [2016]...

Help! I've been trying for hours to get this formula to work and at a loss. I need to get a sum from a range of numbers in Column F on a tab named "R3A". I know the starting cell is always "R3A!F4" but the end of the range will change each month. I'm calculating the end of the range and it's...

HI, I have sheet1(called "Timesheet") and sheet2("Legend"). Into Legend I have: <tbody> Category (columnA) Non Game (columnB) Training (columnC) Sport Value1 Training1 Non Game Value2 Training2 Training Value3 Training3 Project Value4 ... Admin ... .. </tbody> Into Manager Name I...

I have two worksheets in a workbook (WellbeingDashboard); Charts and Data. The data I am looking at includes product data (five products), accounts and user metrics (two metrics), by state (two states). I am trying to create a single chart (stacked area) that trends the change in a user-selected...

Hello All, Stumped on trying to get the Indirect function to return the name of a range. The following formula works when the named range(Maintenance) is hard-coded, but the idea is to make this part of the formula dynamic...

Hi I'm trying to use the indirect function to populate the following formula =SUM('worksheet_1:Worksheet_100'!U2) - This formula works exactly as I want it to..... The values worksheet_1 and Worksheet_100 are to be volatile and taken from cells AA1 and AA2. Cell AJ3 is a number (2 in this...

Hello, I calculated the location of a cell (Acc!BB2). On my output sheet I want to drag the vertical data of this cell just by referring to the reference cell through an indirect function. However, when dragging I only receive the data where the reference cell was calculated but not of the...

Any help would be appreciated, trying to use an indirect with a sumif formula. Here is the sheet: <colgroup><col style="width: 104px"><col width="64"><col width="64"><col width="71"><col width="43"><col width="31"><col width="34"><col width="29"><col width="46"><col width="70"><col...

Search dynamic File Name and pull data from multiple sheets, same cell, into one master sheet I have a user group of approx 100 people that is required to fill out time sheets weekly. The have to submit their timesheets in with a specific naming nominclature in a network folder. I want to...

I have a worksheet with long phrases in Column A, and in Column B, I have a 3-letter snippet from the string in A, thus: STONESTHROW NES 196 REALIGNMENT LIG 35 QUALITYTIME LIT 87 QUALITATIVE LIT 87 In this case, I'm looking for the 3 letters beginning in the 3rd position. I use the MID()...

Alright maybe i am not to verse as i thought i was. I want to use an indirect cell reference as look up points for an index match deal. Easy you say well the cell reference is a table. Sheet 1 contains Table named "LookUp" In sheet 2: Cell A1= "LookUp" I want to write a index match that goes...

Hello, I have an excel file consisting of about 50 worksheets which contain raw data. About 10 of them have names prefixed with a ^ sign. For example: ^Sheet3, ^Sheet4 etc. The remaining 40 sheets are named without any special prefixes. In the summary worksheet, I have a column with the...

Hi All, This is my first post so please be patient. I have simplified what I want to achieve in the following example using kids building blocks of different sizes. First I have a reference table called BlockTypes <tbody> Block Size A 1 B 1 C 2 </tbody> I then have a table that...

Hello experts, I have an excel sheet that is linked to a database. I have noticed when I Refresh Data from the database, my excel formulas that are referencing that data would lose the cell, resulting in a #REF error. To get around this I have been using the =INDIRECT formula. My question...

Hi, below code is taking values from columns =OFFSET(INDIRECT($D$76),$D$79,1,1,COUNTA(OFFSET(INDIRECT($D$76),$D$79,1,1,100))) how to change it that will be taking values from rows?

I have a lookup that Index/Match should perform nicely with the exceptions of a couple of wrinkles. I am consolidating income statement line items from a single store (unit) template. As I open new stores across periods, the I/S line items layer into the model. The line items change on a...

I've been racking my brain trying to figure how to solve this for the last week and a half. The core of my formula works in Excel but not in VBA. The basic concept I'm trying to accomplish is to make one drop-down dependent on the result of another drop-down. The first drop-down has a list of...

=INDIRECT("'"&K$4&"'!"& INDIRECT("'"&K$2&"'!"&"R2"&14):INDIRECT("'"&K$2&"'!"&"S2"&14)) Cell k4 contains sheet name 1 Cell K2 contains sheet name 2 Cells r2 and s2 in sheet name 2 contain letters representing column references, for row 14 I can get the two indirect functions to work...