using a defined Name in a function

C

cole

I'm having a problem referencing a name within a function.

I have a cell on one sheet that list a defined name. Another cell on a
different sheet uses a vlookup function to return the defined name based on a
date range. then in a third cell I have a vlookup formula that uses the 2nd
cell (the returned defined name) as the "array" but it doesn't seem to
recognize this second cell as a defined name and therefore won't reference
the array. Any suggestions?
 
D

Duke Carey

you'll have to wrap the text representing the range name in the INDIRECT()
function
 

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

Visio: copy text of a master shape to User-define Cells (Variable) 0
Reference to a Defined Name in another Workbook 1
using defined name in UDF 11
Vlookup and return sheet name also 2
Insert name and adress from a list in a word document 1
Index using a defined name array 1
Problem with SET & REF function 0
user defined function which increase consecutively while passingbelow cells 12

Top