indirect referencing

Hi, I have a formula where i want to look up a cell which is date populated and then look up the corresponding tab with that date on it. We have tabs of data for every day. I just need to know what formula do i use to look up the tab? So in the below the XXXX part needs to actually be...

A short explanation; I have a large amount of reports in one folder, and they are all formatted the exact same way every time, except for the date in the file name (ex. Out of Stock Report WE 04.20.16.xlsx). In the workbook where I have my formula, I'm referencing a cell that has a date in it...

HI I am having problems with the following Issue: Over 50 sheet containing information for different divisions - name contains spaces and special characters Data Range would be B:L contains headers and title text but the data required always starts at Row 8 The number of Rows varies from...

Hi All, I am trying to use an indirect function but am making an error somewhere. Can anyone please advise? So cell AG2 has the number 25 in it, what i want is the function to look up the controls tab at cell A25. =IF(H4=0, "",INDIRECT("'"&"Controls!$A"&AG2&"'!"&"C27")) Does this make...

This is a first time post so apologies if i transgress the rules. I am using Office 2013 (64-bit) in a Windows 7 environment. I have written the following nested array of index/match with named ranges to create a cumulative list from several named ranges which reside on different sheets/tabs...

Hello, I am having a bit of difficulty and need some help with the following I have 3 sheets called Data-2013 Data-2014 Data-2015 These sheets contain weekly performance data for the designated year and the each row holds the same data, i i.e. row 2 = 'widget sales' row 5 = 'sproket sales'...

Hi, Apologies for raising this, but really struggling to get this working. I have a table, one column in the table will reference one of 15 other columns in the table based on a selection made by a user - I cannot get this to work with INDIRECT and most of the comments I have read indicate as...

I want to sum values in column K given a range of dates from column B. Using the Sum, indirect, offset and match functions. B C D E F G H I J K <colgroup><col><col><col span="2"><col><col...