indirect function

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

I have a workbook where for each new month I am importing data into a new tab and then using SUMIFS to derive a total by data values. Each tab is named Jan 14, Feb 14 etc. I'd like to have a formula that will go to the right tab and select the data based on the month that is input to a cell...

Hi, help would be appreciated. I have the following formula which references another workbook. I would like to reference the column highlighted in red to change per a named cell in my current workbook (not the workbook being referenced). The goal is to create a sum function that can be...

Hi I am guessing this is easy meat for most of you out there, I am new to using INDIRECT, I am still struggling to understand some of the functions, tried using the Excel help and this is still not working for me. My formula is easy COUNTIF(Details!C:C,"Incorrect code") What I want is an...

What I want to do: I have headings in cells B1 to BJ1 which I have copy - paste special - transposed on sheet 2 in cell A2 to A61 . In sheet 1 I have skills from cell A2 to A49 which I have copy - paste special - transpose on sheet 2 in cells B1 to AW1. In cell B2 on sheet 2 I want to put the...

Hi, I have the following function in my workbook: =INDIRECT("'Sheet 1'!J"&$N$1) Cell N1 has the number of the row that the data is on that I want to display. My issue is that the Column "J" is dynamic on a monthly basis. So, I was trying to do something like this in VBA ( I have a lot of...

I am not very good at Excel. I have a problem: I have written the following formula in cell J5 <colgroup><col></colgroup><tbody> =IF(AND(INDIRECT("AF5")<0,INDIRECT("AF5")<INDIRECT("AJ5")),"N",IF(AND(INDIRECT("AF5")<0,INDIRECT("AF5")>INDIRECT("AJ5")),"W","")) </tbody> However, when I copy the...

Hi All, Looking for a little advice here. I am having an issue when I try a chart a named range. The named range "Refers To" is =OFFSET($A$1,(MATCH("Kevin",$A:$A,0)-1),,,COUNTA(INDIRECT(ADDRESS((MATCH("Kevin",$A:$A,0)-1),1,1,1)&":"&ADDRESS((MATCH("Kevin",$A:$A,0)-1),100,1,1)))) As far as I...

Am trying to write a simple program to create a validation list in select cells in a spreadsheet. (Office 2010, Windows 7) This code works: ActiveCell.Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _...

I have some formulas that I want to change with the name of the worksheet. I have a cell called PxW that has the name of the sheet that is the dashboard in it; "10x4" for instance. I make pairs of worksheets; a dashboard sheet that would be called "10x4" and a data sheet that has a matching...

Hi everyone! Here is my problem. I am trying to sum the same cells in different sheet (same template). I create 2 boundaries sheets (BEG and END). Then I use the formula SUM(BEG:END!B2). It works well. However, it is not robust because If I insert a new row before row B in this case, my formula...

Hi. I have this little program where you can add items to an index (it's do with foods). So you select the food category the food belongs to then the macro will put it in the respective place in the index (under the correct category heading and in alphabetical order). I then draw from this index...

Finally breaking down and asking for help with the following function/brick wall. I'm currently using the match function to look up a dollar amount per insulation diameter and thickness. Each different tab is a different type of insulation. I've always had to hardcode in the "Tab Worksheet...

I have this formula in WORKBOOK A that performs a VLookup in WORKBOOK B; =IFERROR(IF(ISBLANK(CONSOLIDATION[@[Host Name]]),"",VLOOKUP(TRIM(CONSOLIDATION[@[Host Name]]),INDIRECT("'[WORKBOOK_B_Rev 1.1.0.xlsx]"&CONSOLIDATION[@[SITE-FE]]&"'!$B$9:$J$8361"),7,FALSE)),"Not Found") This works well. But...

Hi Everyone and thanks for any help in advance. I have an excel spreadsheet in which I am linking to another spreadsheet. From this worksheet I have to return the SUM of an OFFSET. Because of the limitations of the OFFSET function it is ineffective if you change the linked workbook and the...

I have created a summary worksheet that includes data from 10 separate worksheets in the same workbook. I am looking for help with creating a formula that will allow me to copy and paste(relative) from separate worksheets to the summary worksheet. For formula purposes, here are worksheets...

Hi - I was wondering if there is a way to make DSUM work with using multiple criteria possibly including an indirect cell reference. What I'm trying to accomplish is something like this: =DSUM('database',field,A3&L2:L4) I would like A2 to change as I copy the field down the column, the...

Hi folks, I have written some indirect formula functions such as the ones below. =(SUMIF('OPWL (ret)'!$AG:$AG,CONCATENATE($C15," - ",D$6),INDIRECT("'OPWL (ret)'!$AH$2:$AH"&'OP Activity FS'!$C$12))+SUMIF('OPWL (ret2)'!$AG:$AG,CONCATENATE($C15," - ",D$6),INDIRECT("'OPWL (ret2)'!$AH$2:$AH"&'OP...

Ok, I want to have a formula that will fill automatically the specific cell using indirect formula. for example. in sheet1 I have blank cells b1 c1 d1 etc. and I have data base in sheet2. if im going to click across the rows in database like for example Rows("11:11").Select, those selected...

I am using this formula instead of a linked external spreadsheet: =INDIRECT("'[" & $A$1 &" "& $A9&".xlsx]Cost Summary'!" & C$1 & "$" &$B$1) The values in A1 and A9 contain values that change that help build the name of the spreadsheet. If the external reference is open, it auto-updates...