indirect

Hi I am trying (and failing) to pull specific data from 1 sheet "LOG" to a "Request Form" using a sequential number as the guide reference and when the sequential number is changed on the Request Form all the date is entered from the corresponding row in the Log. The data will be inputted...

Hi! I have the formula below. I want the formula to count the data from E17 to Q17, even if I add a new column. I am trying to calculate the last 13 weeks of data at all times and do not want the cell references to change when a new column is added. In other words, I add a column and the...

I've created a dynamic range formula which shows as below: =CONCATENATE("AC SalesRawData!",SUBSTITUTE(ADDRESS(1,C1,4),"1",""),":",SUBSTITUTE(ADDRESS(1,C2,4),"1","")) Which gives me the range output "AC SalesRawData!CQ:DS" I'm then referencing this range in an vlookup using Indirect as shown...

Hi, I have used filter to bring back one text name from a range = LET( fv, FILTER(Sheet1!$G$5:$G$10,Sheet1!$H$5:$H$10="Y"),fv) I would like to feed this into 'Indirect' , but it does not seem to work? if I refer to the cell which the above is in this does. so...

Hi, I've created a formula that works fine if it is within the sheet where the data originates, if is filtering the routes our vans will be taking and excludes any blank routes (if a van is not scheduled out that day). But I want to have the summary in another sheet dynamically changing based on...

Hey, I have a couple of named functions (e.g., functions I entered the name manager, gave them names and can not be invoked by entering the names). E.g., two of the named functions are: "exr_average" and "exr_latest" and they return either the latest exchange rate of a selected currency or its...

I work in Finance and have a QoL-issue with excelling daily. I use INDIRECT and SUMIFS constantly when comparing figures. Oftentimes it's about comparing latest estimates with previous forecasts or budgets in an earlier instances of the same file (although with a different name)...

I have an excel "database" that does various calculations, data collecting and reports for an event that occurs every year. Various reports are generated from specific columns using the indirect function. My question, with the below example, is when I chose 2023, the company names Target and...

Hi, I have a SUMPRODUCT and IF formula which works fine together but I am trying to merge this with an INDIRECT formula: =SUMPRODUCT(IF('No. 1'!$A$1:$A$500=E$4,'No.1'$E$1:$E$500*'No.1'$F$1:$F$500)) No.1 should be the contents of Cell A8, A9 etc. I've tried...

Hello. I am trying to point a cell towards another cell in a different file, but make this dynamic using CONCATANATE to build up the file path & then INDIRECT to complete the task. The formula I have is . . . ="=('"&N3&"/["&O3&"]Dashboard'!"&P1&M3&")" This formulas produces the below text...

I am trying to create a more robust budget and invoice tracking sheet. I track contract values, changes and budgets on worksheet that are named by the financial accounting node they are associated with. I have a column in my project budget sheet that needs to reflect the total value of each...

Hi there, I have an index match match 2-way look up, which returns data based on another tab. (The index match does a vertical look up and then a horizontal one). The formula works fine, but I would like to introduce a variable into the formula to so it looks up the 'correct' tab, corresponding...

Hi, I am trying to consolidate data from the same column of multiple spreadsheets. =INDIRECT("'"&A$1&"'!"&"I14") A$1 is the first worksheet name with other worksheet names in the subsequent columns to the right. I14 is the first cell where the data begins in each worksheet. My formula above...

Hi, I have asked this question on MS website ; Redirecting If I have a an array from indirect ; INDIRECT({"Sheet1","Sheet2","Sheet3"}&"!"&"A1",TRUE) , which returns a spill of "#VALUES" but if F9'd will show ; = {2,3,4} , which is...

Hi all. Quick question: Does anyone know how to update the formula in I22 to make it be fed by the cell reference i hardcoded into A19? I tried replacing the H60 in the Indirect formula with "text(A19))" but that doesn't work. The reason I would like to do this is so that I can copy and...

Hi there. Can anyone help me with an indirect with nested index match formula that's dynamic enough to allow me to get values from other sheets which change depending on the Factory and Metric I need them for? My hope is to have one formula that's dynamic to copy it across and down as the file...

I have an invoice reconciliation workbook where the first sheet (Data) is a list of the Planned Amounts by Vendor and Project ID. All of the other sheets in the workbook are broken out and named by the Project ID. I'm trying to compare the Planned Amounts by Vendor on the Data sheet to the Total...

Hi, In the following formula I have type in the "A2:A6"; SUMIF(INDIRECT("'"&Sheets&"'!"&"A2:A6"),"a",INDIRECT("'"&Sheets&"'!"&"B2:B6")) Sheet = named range is there a way to have the reference to A2 to A6 in other cells so a cell A1 = "A1", A2 = "A6" and then just select those two...

Hi Guys i have the following formula which I need to autofill down to 3800 rows A1 ON PORTAL SHEET has a code which referes to a tab sheet name A2 refer to the cell from that particular sheet I wish to retrieve the data. the cell the first formula is in is X1, there the formula will autofill...

Is there a way I can shorten this formula. Works - This adds "US", "VI", "PR", and excludes "CA"...