indirect function

Hi all, Longtime lurker/reader, first time poster! I'm looking for some help creating (for me) quite an advanced excel formula. I think any separate part of this i'd be fine with but combined together has somewhat melted my brain. Any help would be greatly appreciated, new to forums so let me...

Hi, I have a workbook with several sheets, which all have data in the same format but with different numbers. I am trying to create a summary sheet, which pulls the data from each individual workbook and lists it. As VBAs are disabled and I have never created a macro before, I am trying to...

Hello, I'm currently using the following CF Rule to highlight cells in two columns that meet a single criteria from a list on another sheet. =SUM(COUNTIF(C2,"*"&INDIRECT("t_Whitelist[Author-Series]")&"*")) However, I would like to expand my criteria to only highlight the cells that meet the...

Hello, I'm having some trouble getting a Conditional Formatting Rule to work using the INDIRECT function. I'm using a formula within the Table for testing in column 'C'. Column 'E' - outside the Table - was converted to use the INDIRECT function to work from outside the Table. Columns A:B...

Hi Folks - Thanks in advance for taking a look at this. I need to use the indirect function to help me reference a cell on another worksheet - I cannot see the error that is being triggered - see below. Any help appreciated. Thanks - Mark.

I am trying to write a formula in excel. I have a summary sheet that has equipment numbers in one column and sheet reference values in a row. I also have multiple sheets that have names equal to the values in the row mentioned. I want to use the indirect function to sum the range in column G of...

Hi guys, I am trying to use INDIRECT with dependant drop downs. I have one worksheet, column R is drop down with two choices (Customer, Courier), Column S should display a drop down of choices varying - depending on the choice made in Column R. So I created dependent drop downs: in another tab...

I am using the formula B1=COUNTIF(INDIRECT(A1&"!E:E"),"<>")-1 But when there is space in between in Column A then I am getting error as #REF!, for example when I have cell value as "REDORANGE" its showing value but when I am using "RED ORANGE" its showing #REF! and my sheet name is "RED...

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

Hello everyone, I'm currently using the indirect function with the IF function to identify if O111 is equal to N112. The problem that I have is if I delete or add any rows the indirect function won't move to follow the last value on the O column. Do you guys have any ideas on how I should...

Hi all, Wondering if you could help me here. I am trying to create some profiles for some players in which I change the name and their picture changes. I have created a table with their picture next to their name and followed some instructions online to make dynamic pictures however I keep...

Quick question regarding some references I have to external workbooks. The formula in question is: =VLOOKUP("*"&B5,INDIRECT('Links to Workbooks'!$I$3),'Links to Workbooks'!$C$4,FALSE) Where the lookup value B5 contains "Total Revenue" and is what I am hoping to match using VLOOKUP in other...

Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...

I'm trying to build a formula (in column G) that basically says, "If the worksheet that is named with the value of C2 on this worksheet has "Late" in the 2nd to Last Row, return Late. Otherwise, return the value of the Last Row." My challenges are: The sheets that I'd be searching on are...

Hello all, I have a spreadsheet with a number of companies, each one with 3 specific values that I would like to be able to put in and out of spreadsheets. When I select one of my companies using data validation list I would then like the 3 corresponding values to automatically fill in the...

So here is what I am trying to do: =IFNA(IF(ISNONTEXT(U7),"",RANK.EQ(W7,INDIRECT(M7&N7):INDIRECT(O7&P7)+COUNTIF($W$7:W7,W7)-1),"") I am trying to establish a ranking on different items down a list so there are as many as 50 items and 20 subsets of each item, I put them all in the same list for...

Hello all, I have had some great tips etc. from you Excel Experts and am hoping for more. You recently solved my 'INDIRECT' question which works well but now I am looking to copy 'cars in stock' data from a sheet in last years workbook into a stock book sheet in this years workbook. I would...

This is the string that produces a working formula. =CONCATENATE("=SUMIF(Table_Data[Date],TODAY()-",$B15,",Table_Data[",C$26,"])") C26 - is the header of the table B15 - is the number of days current or before <tbody> The result is a formula that I can paste into notepad, then re-copy into...

Dear Excel Experts, I have some details like this, Customer . . . Style Name Max . . . . . . FB06 Max . . . . . . 701XT OVS . . . . . . MARK Strd . . . . . . TRO002 I want data validation list of unique customer and in other column i want...

In 2016 trying to substitute Indirect for manually entered sheet name (bold) in following: =IFERROR(INDEX('FYE2015'!$D$4:$D$1322,MATCH('3DRev'!I$6,'FYE2015'!$B$4:$B$1322,0)),0) I have a range of sheet names in column B (FYE2006 to FYE2017)