Match/ Index question

[Cory Tilton]

I want to use a named chart in a match lookup function as a part of my
vlookup equation. The problem when I am encountering is it is reading
the name of the chart as just a cell value and not pulling the
information from that chart. Does anyone know how to embed the name of
a chart so you can use it in a function. Below is an example of my
problem.

=vlookup(a1,index(r202:r206,match(d214,s202:s206,0)


the 'r202:r206' are my charts, but excel is just reading them as cells

 

[isabelle]

hi Cory,

you can not use the cell address to name a cell range


--
isabelle




Le 2012-02-08 16:14, Cory Tilton a écrit :

 

[isabelle]

so you can not use "A1:A10" to do name a cell range
but you can use "add_A1:A10"
or anything else to replace "add_"