• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Indirect Named ranges to lookup data of different Dimensions

A

Alastairwc

New Member
Hi there


I have a number of sheets all with the same number of columns and same named columns.


Example of column headings are Date, time, Expenses etc..


However each sheet has a different number of rows of data.


I want to create a summary sheet that just looks up the data for the respective sheet. Ive tried this by using named ranges. Eg: =Indirect(A1 & "!Named Range_1") but this is returning errors.


Any Ideas?
 
Hi Alastair ,


The syntax of the INDIRECT function is detailed here :


http://chandoo.org/forums/topic/i-m-not-getting-the-value-of-a-cell-which-have-contains-path-in-vlookup-formula


Can you say what A1 contains , and what Named_Range_1 refers to ?


Narayan
 
You must log in or register to reply here.
Back
Top