Hi all

I wonder if someone could please help me solve this issue, i have done 
examples files to help someone look at this issue

***********************************************************************
Example files :

2003
http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xls

2007
http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xlsx
***********************************************************************

What i am trying to do is have a block of data / values that i need to 
refer to over and over again

I am trying to do this with the a range name

For this example

On Sheet1
I have a table price grid for a product let say sheet 1 a1:g19 
I have named this as a range ref_pricelist

On sheet2 

I want to show variations of ref_pricelist with additional formula to be 
applied to that original range

I know that if i use =ref_pricelist and the cells start and finish 
exactly at the same row and col reference i can do that but when i want 
to refer to it again on the same page all i get is #value


Sorry it may not be the clearest but i do have an example of what i am 
trying to do .. which can be downloaded from

it shows the a sheet with the problem and then a working example but 
using cell references to show an idea

please can some one point me in the right direction to refer to a range 
anywhere repeatively on sheet which is not is the perfect overlay 
location 

i been trying to play with indirect, offset etc.. just starting to look 
at address but not too sure what i should be using

pleased to hear from anyone who can point me in the right direction

thank you

You can use:

=3DINDEX(ref_pricelist,5,2)

to get the data from row 5 and column 2 (relative) of your table.

The 5 and the 2 don't have to be constants - they could be some
calculation, or cell references which contain numbers.

Hope this helps.

Pete

On Feb 15, 9:40=A0am, Nick C <itsupp...@bradrail.co.uk> wrote:
> Hi all
>
> I wonder if someone could please help me solve this issue, i have done
> examples files to help someone look at this issue
>
> ***********************************************************************
> Example files :
>
> 2003http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xls
>
> 2007http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xlsx
> ***********************************************************************
>
> What i am trying to do is have a block of data / values that i need to
> refer to over and over again
>
> I am trying to do this with the a range name
>
> For this example
>
> On Sheet1
> I have a table price grid for a product let say sheet 1 a1:g19
> I have named this as a range ref_pricelist
>
> On sheet2
>
> I want to show variations of ref_pricelist with additional formula to be
> applied to that original range
>
> I know that if i use =3Dref_pricelist and the cells start and finish
> exactly at the same row and col reference i can do that but when i want
> to refer to it again on the same page all i get is #value
>
> Sorry it may not be the clearest but i do have an example of what i am
> trying to do .. which can be downloaded from
>
> it shows the a sheet with the problem and then a working example but
> using cell references to show an idea
>
> please can some one point me in the right direction to refer to a range
> anywhere repeatively on sheet which is not is the perfect overlay
> location
>
> i been trying to play with indirect, offset etc.. just starting to look
> at address but not too sure what i should be using
>
> pleased to hear from anyone who can point me in the right direction
>
> thank you