Match/ Index question

C

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
 
I

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 :
 
I

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_"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index with partial text 1
Index match with multiple criteria(different than usual) 3
Index/Match with text-looking numbers 1
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
problem with index formula 2
Drop down list from index/match formula 1
Dynamic charts with named range Windows 8.1 3
Stacked Bar Chart 1

Top