indirect function

  1. N

    Use different sheet names as part of a formula (indirect function?)

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

    CF Rule: Highlight Range using Multiple Criteria

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

    Conditional Formatting (CF Rule) Using INDIRECT Function

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

    Error using Indirect function that links to a value in another worksheet

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

    Writing a formula to sum a specific range from a sheet if another range in the same sheet is equal to a cell value in a third summary sheet

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

    Google Sheets - problem with INDIRECT formula with data validation

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

    Excel count if sheet name matches with Column E with cell value

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

    INDIRECT doesnt work properly

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

    Indirect function with relative movement

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

    Dynamic Pictures based one someones name

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

    References to external workbooks not working unless they are open

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

    Alternatives for INDIRECT in cascading (dependent) dropdown lists causing slowdown and headaches

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

    Nesting Formulae with INDIRECT Function, Across Dynamic Sheets

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

    Creating dependent list

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

    Multiple Indirect functions in same equation

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

    Getting Data From Last Years Accounts Workbook

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

    Running Formula from a concatenated string.

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

    Unique Data Validation List with indirect function

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


    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)
  20. M


    I have a VLOOKUP formula that I am currently using =VLOOKUP(B1986,'QC T4 BOD'!$A$373:$D$517,4,0) What I am trying to do is avoid having to manually change the $373: $517 part of the formula every time I drag the formula down The start and end refers to the cell address, I would like to use...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back